I have an ArrayList of string[] objects that I just want to dump to an Excel spreadsheet.
All the string[] objects are the exact same length, no null values.
How do I create an Excel file without Interop?
I'm trying
objCmd.CommandText = "Insert into [Sheet1$] values('a','b')";
after I manually create a file.. and sometimes that has worked and sometimes it will tell me "number of query values and destination fields are not the same".
I don't use column names. I just want to dump the values.
Any ideas?
All the string[] objects are the exact same length, no null values.
How do I create an Excel file without Interop?
I'm trying
objCmd.CommandText = "Insert into [Sheet1$] values('a','b')";
after I manually create a file.. and sometimes that has worked and sometimes it will tell me "number of query values and destination fields are not the same".
I don't use column names. I just want to dump the values.
Any ideas?