Hi,
I need to get a picture from a diagram in another language (Spain in this case).
But I got only the English translation for Increase, Decrease, Total even though I changed the Culture of the workbook. When I open it with a Spanish Regional Setting, it is translated in Spanish.
Here are the files: XL.zip (333.0 KB)
Here is the code
xlsLic.SetLicense(“Aspose.Total.lic”);
CellsHelper.DPI = 96;
Workbook w3 = new Workbook(“Xl_V2.xlsx”);
w3.Settings.CultureInfo = new System.Globalization.CultureInfo(“es-ES”);
Worksheet excelWorksheet = w3.Worksheets[“Hoja1”];
Aspose.Cells.Range range = excelWorksheet.Workbook.Worksheets.GetRangeByName(“BIPLI_PRUEBA_CASCADA”);
string startCell = CellsHelper.CellIndexToName(range.FirstRow, range.FirstColumn);
string endCell = CellsHelper.CellIndexToName(range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1);
string rangeAddress = string.Format("{0}:{1}", startCell, endCell);
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.AllColumnsInOnePagePerSheet = true;
options.ImageType = Aspose.Cells.Drawing.ImageType.Emf;
//options.ImageFormat = ImageFormat.Emf;
options.OnePagePerSheet = true;
options.HorizontalResolution = 600;
options.VerticalResolution = 600;
options.OnlyArea = true;
Aspose.Cells.PageSetup pageSetup = excelWorksheet.PageSetup;
pageSetup.PrintArea = rangeAddress;
using (MemoryStream imageStream = new MemoryStream())
{
SheetRender sr = new SheetRender(excelWorksheet, options);
sr.ToImage(0, imageStream);
Image.FromStream(imageStream).Save("PRUEBA_CASCADA.png", ImageFormat.Emf);
};
Kind regards,
Nachti