使用S preadsheetgear为Excel单元格值本地化（.NET） [英] Localizing value for Excel cell using spreadsheetgear (.Net)

问题描述

我想用本地化净小号preadsheetgear DLL Excel单元格的值，当我尝试生成excel的我起诉葡萄牙人数字格式为[= 0] 0​​; ## ###。 ＃00，它应该显示值作为2.265,65，但这没有发生，它会显示为2,265.65（。是没有得到替换，为葡萄牙语），请大家帮帮我是那里的任何限制Excel或我们需要应用电气特性的数字格式

I am trying to localize the excel cell value using .Net spreadsheetgear dll, When i try to generate the excel i am suing the portugese number format as "[=0]0;###.###,00" which should display the value as 2.265,65 , but this is not happening and it is displaying as 2,265.65( "." is not getting replaced with "," for portugese), Please help me is there any limitations in the excel or do we need to apply anyother number format

谢谢
苏哈

推荐答案

是code。 pleae帮助我们在固定的问题。

below is the code. pleae help us in fixing the issue

Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook(CultureInfo.CreateSpecificCulture("pt-BR"))
Dim monthlysheet As SpreadsheetGear.IWorksheet
monthlysheet = CType(workbook.Worksheets.Add(), SpreadsheetGear.IWorksheet)
Dim range As SpreadsheetGear.IRange = monthlysheet.Cells("A10")
range.CopyFromDataTable(dtSCU, SpreadsheetGear.Data.SetDataFlags.None)

Dim NumberRange As String = "A11:F11"

    worksheet.Range(NumberRange).Validation.Delete()
        worksheet.Range(NumberRange).Validation.Add(ValidationType.Decimal, ValidationAlertStyle.Stop, ValidationOperator.Less, 9999999999999999, "")
        worksheet.Range(NumberRange).NumberFormat = "[=0]0;###.###,00"
        worksheet.Range(NumberRange).Validation.InputMessage = "Enter a Number."
        worksheet.Range(NumberRange).Validation.ErrorMessage = "Please enter a valid Number."
        worksheet.Range(NumberRange).Validation.ShowError = True
        worksheet.Range(NumberRange).Validation.IgnoreBlank = True
        worksheet.Range(NumberRange).Locked = False

这篇关于使用S preadsheetgear为Excel单元格值本地化（.NET）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！