Ladda arbetsboken med specifik systemkulturinformation
Contents
[
Hide
]
Möjliga användningsscenarier
Tidigare måste du ändra kulturinformationen för hela tråden för att hantera siffror och datum i ett visst kulturformat, men nu ger Aspose.CellsLoadOptions.CultureInfoegenskap som du kan använda för att ladda din arbetsbok med specifik kulturinformation utan att ändra kulturinformationen för hela tråden.
Ladda arbetsboken med specifik systemkulturinformation
Följande exempelkod visar hur du laddar arbetsboken med specifik systemkulturinformation för att hantera datum.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| using (var inputStream = new MemoryStream()) | |
| { | |
| using (var writer = new StreamWriter(inputStream)) | |
| { | |
| writer.WriteLine("<html><head><title>Test Culture</title></head><body><table><tr><td>10-01-2016</td></tr></table></body></html>"); | |
| writer.Flush(); | |
| var culture = new CultureInfo("en-GB"); | |
| culture.NumberFormat.NumberDecimalSeparator = ","; | |
| culture.DateTimeFormat.DateSeparator = "-"; | |
| culture.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy"; | |
| LoadOptions options = new LoadOptions(LoadFormat.Html); | |
| options.CultureInfo = culture; | |
| using (var workbook = new Workbook(inputStream, options)) | |
| { | |
| var cell = workbook.Worksheets[0].Cells["A1"]; | |
| Assert.AreEqual(CellValueType.IsDateTime, cell.Type); | |
| Assert.AreEqual(new DateTime(2016, 1, 10), cell.DateTimeValue); | |
| } | |
| } | |
| } |
Följande exempelkod visar hur du laddar arbetsboken med specifik systemkulturinformation för att hantera siffror.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| using (var inputStream = new MemoryStream()) | |
| { | |
| using (var writer = new StreamWriter(inputStream)) | |
| { | |
| writer.WriteLine("<html><head><title>Test Culture</title></head><body><table><tr><td>1234,56</td></tr></table></body></html>"); | |
| writer.Flush(); | |
| var culture = new CultureInfo("en-GB"); | |
| culture.NumberFormat.NumberDecimalSeparator = ","; | |
| culture.DateTimeFormat.DateSeparator = "-"; | |
| culture.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy"; | |
| LoadOptions options = new LoadOptions(LoadFormat.Html); | |
| options.CultureInfo = culture; | |
| using (var workbook = new Workbook(inputStream, options)) | |
| { | |
| var cell = workbook.Worksheets[0].Cells["A1"]; | |
| Assert.AreEqual(CellValueType.IsNumeric, cell.Type); | |
| Assert.AreEqual(1234.56, cell.DoubleValue); | |
| } | |
| } | |
| } |