Fill data in Excel table

  • Thread starter Thread starter Nikolay Petrov
  • Start date Start date
N

Nikolay Petrov

I need to fill data in Excel table. I have an Excel workbook, where
some values should be filled in specified cells. I need to do this
without COM interop, because i don't have Excel installed. I red that
ADO.NET does not support 'Insert' and 'Update' statments against excel
files. Any ideas how to fill the table?

TIA
 
Hi,

If you can't use automation and Jet OLE DB doesn't have the power you need,
only other solution is to use some third-party control. If the amount of
data you are exporting is not large (less than 5 sheets and 150 rows per
sheet), you have ExcelLite Free component you can freely use in commercial
apps (http://www.gemboxsoftware.com/ExcelLiteFree.htm). If your worksheet
grows in size, you can easily update to ExcelLite Professional.

Jan
GemBox Software
www.gemboxsoftware.com
 
I need to fill 10 to 20 cell only. at specific locations in excel
template. that's all
 
Ken. It was my mistake. Before some time, i've tried to delete records
in excel file, and I red this KB article. This time, i forgot that only
deletion is not possible. Sorry, my memory is not so good these days.
Thanks however.
 
Back
Top