There are two(2) question in this discussion:
[1] How can I insert the text and page no# into excel "Header and Footer" area from X++?
[2] How can I set the margin from the X++?
[1] How can I insert the text and page no# into excel "Header and Footer" area from X++?
Could you please tell me how to insert the text and the page number into the Excel "Header and Footer"? I am writing a program to export the data into the excel worksheet. It also need to insert some text in the EXCEL Header area and insert the page number in the EXCEL Footer from X++.
[2] How can I set the margin from the X++?
The standard width of margin for the excel worksheet is not enough to show the data. After the margin has been set to Narrow, the width of the page can be shown the data in a line in the worksheet.
Program Flow
The program flow which is the user choose the MO from the production master and click a button to export the carton list. After the list has been generated, the user only click the "Print" button to printout the excel file. Therefore, insert the text in the header area, page number in the footer area and custom the specific margin in left hand side and right hand side should be completed after the excel has been generated.
Please advise me the method to complete these tasks. Thank you very much.
