The files are not properly recognized when the base64 string representing the exported XLS file is converted using https://base64.guru/converter/decode/file.
If an XLS file produced by MS Excel is converted with the same tool, it is generated with .bin extension.
When the column has cells that span several rows, the auto fit of column width is not working.
Workaround: If the document is being generated with the API, autofit the contents before merging the data.
Importing XLSX file in Blazor Web Assembly for .NET 5.0 is very slow.
<InputFile OnChange="@HandleFileSelected" />
async Task HandleFileSelected(InputFileChangeEventArgs e)
{
var ms = new MemoryStream((int)e.File.Size);
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
using (Stream ey = e.File.OpenReadStream(e.File.Size))
{
await ey.CopyToAsync(ms,(int)e.File.Size);
ey.Close();
}
oWorkbook = formatProvider.Import(ms);
}
To reproduce:
CultureInfo cultureInfo = new CultureInfo("es-ES");Hello,
I am writing a piece of code in VB that converts Excel files that a user uploads into PDF files. It merges all of them into one fixed document and exports that fixed document to a PDF. Whenever I upload specifically the "Schedule" default layout from Google Sheets, exported to xlsx format, all my times are changed from 9:30 AM or 1:28 PM to 9:12 AM and 1:12 PM respectively.
Reproduction Steps:
A few key notes that may help with resolving the issue :
Below I have written a snippet of my code, as well as included the xlsx file and the pdf file that results from it. I am using one of the latest versions of Telerik Document Processing, having been downloaded on 6/25/2021.
Case".xlsx"
Using infileStream As Stream = File.OpenRead(inputFilePath)
Dim inputFormatter AsNew Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider
Dim imported As Spreadsheet.Model.Workbook = inputFormatter.Import(infileStream)
imported.ActiveWorksheet.WorksheetPageSetup.PaperType = Model.PaperTypes.Letter
imported.ActiveWorksheet.WorksheetPageSetup.CenterHorizontally = True
imported.ActiveWorksheet.WorksheetPageSetup.FitToPages = TrueDim format AsNew Spreadsheet.FormatProviders.Pdf.PdfFormatProvider
Dim fixedDoc As Fixed.Model.RadFixedDocument = format.ExportToFixedDocument(imported)
primaryDoc.Merge(fixedDoc)
EndUsing