Free Spire.XLS LoadFromFile set sheet name

[sconly]

With Free Spire.XLS is it possible to set the sheet name using LoadFromFile (method)?

I'm converting csv files to xlsx files and some of the filenames are over 31 characters long, and as a sheet name can only have a max of 31 characters I get an error message.

Is there any workaround, other than renaming the file before converting it?

Thanks

[Brian.Li]

Hello,

Thanks for your inquiry.
For CSV files with a file name longer than 31 characters, you can load it from stream(as shown below), I have verified that this will not throw errors.

Code: Select all

            FileStream fileStream = new FileStream("your filename.csv", FileMode.Open);
            Workbook wb = new Workbook();
            wb.LoadFromStream(fileStream, ",", 1, 1);
            wb.SaveToFile("result.xlsx");

If there are any questions, please feel free to contact us.

Sincerely,
Brian
E-iceblue support team

[sconly]

Brilliant.

Thanks for the help.

One thing I would add is to close the FileStream, so the file doesn't get locked, by adding the following code...

Code: Select all

fileStream.Close();

[Brian.Li]

You are welcome.
If you encounter any issues related to our products in the future, please feel free to contact us.

Sincerely,
Brian
E-iceblue support team