ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to modify excel setting using VB.Net (https://www.excelbanter.com/excel-programming/311895-how-modify-excel-setting-using-vbulletin-net.html)

RegWright

How to modify excel setting using VB.Net
 
I have a VB.net application that outputs report from datagrid to excel.

I now need to modify the setting to print landscape and add a header with
date time exc.

I use Response.AppendHeader("Content-Disposition",
"inline;filename=test.xls")

Does Excel have doc on how to modify properties using VB.net?


All times are GMT +1. The time now is 05:15 PM.

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