开发者

Regarding Excel object

开发者 https://www.devze.com 2022-12-13 21:48 出处:网络
i am using ADO.Net oledb for inserting and fetching data from Excel database. I want to make first column in the excel sheet to bold and i want to add comments. 开发者_运维百科I am achieving this thru

i am using ADO.Net oledb for inserting and fetching data from Excel database. I want to make first column in the excel sheet to bold and i want to add comments. 开发者_运维百科I am achieving this thru Interop.Excel Application class.

i dont want to use interop. is there anyway to achieve through ADO.net query itself ? or some other way? My application is c# windows application


No way through ADO.NET, any more than there is of making a SQL Server column bold. ADO.NET treats Excel as a data source - formatting is something quite different and requires knowledge of the Excel spreadsheet format, such as you'd get via Interop. There are probably other libraries you can use if you search...

0

精彩评论

暂无评论...
验证码 换一张
取 消