Fill data in Excel table

[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

[Ken Tucker [MVP]]

Hi,

http://support.microsoft.com/default...b;en-us;316934

Ken
---------------
"Nikolay Petrov" <jo******@mail.bg> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

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

[Jan]

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
"Nikolay Petrov" <jo******@mail.bg> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

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

[Nikolay Petrov]

I need to fill 10 to 20 cell only. at specific locations in excel
template. that's all

[Nikolay Petrov]

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.