Fill data in Excel table

12 Nov 2005 8:48 AM

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

12 Nov 2005 12:05 PM

Ken Tucker [MVP]

Hi,

http://support.microsoft.com/default.aspx?scid=kb;en-us;316934

Ken
---------------
Show quoteHide quote

"Nikolay Petrov" <johnt***@mail.bg> wrote in message
news:1131785282.580307.230070@g43g2000cwa.googlegroups.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
>

12 Nov 2005 2:23 PM

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.

12 Nov 2005 2:08 PM

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

Show quoteHide quote

"Nikolay Petrov" <johnt***@mail.bg> wrote in message
news:1131785282.580307.230070@g43g2000cwa.googlegroups.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
>

12 Nov 2005 2:20 PM

Nikolay Petrov

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