I'm not sure about the memory issues, as a powerful enough machine should solved that problem, however it sounds as if you are using Excel 2003. Excel 2003 is limited to 65,536 rows by 256 columns per worksheet. The number of worksheets is only limited by available memory. If you move to Excel 2007 you can go up the the limit of 1,048,576 rows by 16,384 column per worksheet, with the number of worksheets is limited by available memory. So either loop and create multiple sheets, or upgrade to 2007. Either way ensure you have a shed-load of memory available. Excel 2003 Limits[^] Excel 2007 Limits[^]
If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles] [My Website]
Try to use Spire.DataExport - it is c# data export component that supports data export into MS Excel,MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format.
I think my previous answer was quite clear. JUST ENSURE THAT THE FILE EXISTS, if it does not exist, you will get this error. Hint: You may use File.Exists() method to skip files that do not exist.
//Create folder in server fso = Server.CreateObject("Scripting.FileSystemObject"); fso.CreateFolder("d:\New Folder1"); //example 2 System.IO.Directory.CreateDirectory(Server.MapPath("path_name")+ "\\NewFolder1");
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
Check the link in my reply to the post below. Hope it helps.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
you should clarify what you want, not delete your post. You needed a LOT of help with the code that was posted, why not ask, and get the help you need ? For a start, using strings for different settings is bad, use an enum. The rest was messy, but that's the only specific thing I remember.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
