Hello,
Thanks for your response.
We are sorry that there is no option to open a workbook without saving it.
As for autofitting column width, please refer to the following code.
- Code: Select all
…
for (int i = 1; i <= sheet.LastColumn; i++)
{
sheet.AutoFitColumn(i);
}
…
Besides, regarding the warning "Number in the field formatted as text", do you mean this?
- screenshot.png (8.2 KiB) Viewed 3136 times
If so, please refer to the following code to remove it. Or if I misunderstood, please describe it in detail.
- Code: Select all
…
sheet.Range["B1:B5"].ConvertToNumber();
…
Sincerely,
Brian
E-iceblue support team