Excel Spreadsheet
-
Hello, How to create not scrollable row(s) in Excel file, like a header? For example: I want that first 3 rows in my excel file would always stay on top. Thanks.
Ehhh ummm... you know how to make it in excel and you want to generate a file like that programmatically ? In that case, an easy solution would be to record a macro do the steps manually, and then port that macro recorded to Excel Automation. A more cleaner way could be to use XMLSS but I dunno if this can be made using Excel XML (try to save the doc as XMLSS and see if it works, in that case you will get the XML entries to do that). Good Luck /// ----------------------- Braulio Díez http://www.bdiez.com /// -----------------------
-
Ehhh ummm... you know how to make it in excel and you want to generate a file like that programmatically ? In that case, an easy solution would be to record a macro do the steps manually, and then port that macro recorded to Excel Automation. A more cleaner way could be to use XMLSS but I dunno if this can be made using Excel XML (try to save the doc as XMLSS and see if it works, in that case you will get the XML entries to do that). Good Luck /// ----------------------- Braulio Díez http://www.bdiez.com /// -----------------------
-
Hello, How to create not scrollable row(s) in Excel file, like a header? For example: I want that first 3 rows in my excel file would always stay on top. Thanks.
Hi. Select the last row you want to be fixed, then select Window...Freeze Panes from the menu bar Regards, Graham.