Save from excel
-
Hi everybody. Im am working in an application and i need save the information in an excel file into a dataset, or an array. Anybody can tell me how can i do that? If anybody can help me i will be gratefull.
1. You can use ODBC and read Excel data. That data you can store anywhere you want. 2. Using Excel.Application object, you can read information form Excel sheet and save it to array or where ever you want. :):) - ashish
-
1. You can use ODBC and read Excel data. That data you can store anywhere you want. 2. Using Excel.Application object, you can read information form Excel sheet and save it to array or where ever you want. :):) - ashish
Using the Excel.Aplication object you do a so called early binding. This is the best way, if you are shure, that your customers use the same Excel-version as you use. If that is not shure, you have to use a late binding, which is much more complicate. But there are descriptions about this way. (I 'm just working on such solution, and put a http://www.codeproject.com/script/comments/forums.asp?forumid=1649&df=100&mpp=50&fr=51&select=1143236#xx1143236xx in this list, but got no answer until now. Perhaps you should look http://www.codeproject.com/dotnet/ExportToExcel.asp too. There is also a way to write an Excel 2.1 output direct to a file. (I did that just (reading a standart *.xls file and add my data in BIFF format. It is not too difficult). Ask me if you are interested.:) Ariadne