ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   export from sqlserver in html format with .xls extension and enabling DisplayGridlines (https://www.excelbanter.com/excel-discussion-misc-queries/127443-export-sqlserver-html-format-xls-extension-enabling-displaygridlines.html)

[email protected]

export from sqlserver in html format with .xls extension and enabling DisplayGridlines
 
hello, i do the following trick... writing html into a .xls file (from
sql server, for an export - just to have the STUPID zeros not removed
by STUPID .CSV format) . so, everything works smooth, just
DisplayGridLines is set from some unknown reason to me to false :( ...
any fix ? notice that i can't run vba from sql server ;)



All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com