I have two questions regarding to XlsIO,
1. when set a value to the sheet
sheet.SetValue(1, i++, "30");
My intention is that I want the cell value to be string 30, however, after opening the Excel, the Excel shows a warning that I might have data type problem (see attm). How can I programmically set the used range in the worksheet to have only text value, so that Excel never show this warning icon?
2. If I want to create only a single sheet in a workbook and do not want the user to add more sheets, can I programmatically hide the Insert Sheet tab at the bottom (see attm)?
Thank you.
Screen Capture_48a5fc56.zip