Posted to microsoft.public.excel.programming

jnc[_2_]

external usenet poster

Posts: 2

Fastest way of getting data into excel

Hi Everyone

I am writing an app at the moment which has to import a large amount of data (1m + cells) into excel and am currently using the excel object model to do this. I am using the cells value property to do this i.e 'objsheet.Cells(1,1).value = x'

I have noticed that usings the cell object model seem to be very slow is there a faster way of getting the data into excel

Cheers.....Ji

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
seeking the fastest workflow for converting bmp image into Excel orASCII table with numbers	LunaMoon	Excel Discussion (Misc queries)	3	September 29th 08 06:14 AM
EXCEL, VSTO: Fastest way to access multiple cells	Alan	Excel Discussion (Misc queries)	1	June 1st 05 02:45 PM
What is fastest way to print labels from Excel data?	Janis	New Users to Excel	1	April 12th 05 10:37 PM
fastest hardware for excel	N Lennox	Excel Programming	2	April 12th 04 07:30 PM
Need FASTEST way to get data from a large closed Excel File	Dave B[_5_]	Excel Programming	13	October 29th 03 09:26 PM

All times are GMT +1. The time now is 06:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us