I am using the latest Version of Aspose.Cells and using .Net .
Here is how my program works:
- I upload a excel and initiate a Workbook
- I use aspose to change some value in the excel.
3.After that, I will export excel file as pdf by using Aspose.Cells.Save().
While some excel will give an exception which is Culture ID xxxxx (0xXXXX) is not a supported culture.
The reason is the excel file set some format on some cells and the window does not support the culture.
I want to block the excel when uploading the excel if that contains some unsupported culture. So, i export once when i upload any excel so i can know if the excel contains any unsupported format. However, if the cells with unsupported format but it does not have any value. It still can export.
Here is my question:
- Is there anyway to check if there is any cell has set format(Like: date, currency, etc)?
- Is there any suggestion/method to handle this case on step 1 of my program (Check any unsupported culture format when uploading.)?
3.(This question may not relevant to this topic but this bothers me) Is there any way to get a cell range which is actively using (From the top left cell to the bottom right cell)?