I need to open a spreadsheet from a template in my project. I'm referencing this article: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-workbooks/create-open-and-save-workbooks#open-a-workbook
The immediate issue I have is I don't think I have the right libraries. I'm starting just trying to open the file. I get an namespace error.
public async Task PopulateReport()
{
string filePath = "~/misc/report_template.xlsx";
Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
// the XLSX format provider is used for demo purposes and can be replaced with any format provider implementing the IWorkbookFormatProvider interface
IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
using (Stream input = new FileStream(filePath, FileMode.Open))
{
workbook = formatProvider.Import(input);
}
}
I have the Telerik.UI.for.Blazor package installed. My understanding was that document processing was included. What am I missing? I guess its worth mentioning I don't have a login to Telerik Nuget. I think it has to do with my company's licensing, I downloaded the package from an internal website.
I have data like this in CLOB field in the database. When a user downloads the data, it's converted to an Excel file using OpenXML.
Customer name¤Active¤customer id¤agreement name¤agreement id¤fund isin¤fund id¤rate active¤agreement active¤agreement vp key type¤agreement vp number¤rate type¤rate commision
I am converting the site so it can run in Kubernetes using the Blazor UI components. Today it's an old MVC site.
So how can I convert all the lines of code to an Excel sheet without using too much memory?
Each CLOB is around 32mb.
I'm trying to use the "ExportToHTML" object but it won't let me. I already implemented the two necessary libraries but it still won't let me use the object.
using Telerik.WinControls.Export;
using Telerik.WinControls.UI.Export;
Any solution?
Greetings All,
Is there any way that the text that i am entrering into Block can be formated for Underline and Strikethrough .
I was able to achieve other properties like Bold , Italix with statements like
block testblock =testCell.Blocks.AddBlock();
testblock. TextProperties.Font = FontsRepository.TimesItalic;
Hi,
I get HTML in my code and I have the image byte in another file. I want to combine it to export my HTML to PDF with images. This is what I do, and it only works with a single image, on the second iteration I got an error in importSettings.LoadImageFromUri (Method = <Internal Error evaluating expression>). What can I do to add multiple images in the importSettings? I don't see an example in the documentation.
foreach (var img in imageList)
{
EventHandler<LoadImageFromUriEventArgs> loadImageFromUri = (s, e) =>
{
byte[] data = img.ContentBytes;
e.SetImageInfo(data, "jpg");
};
importSettings.LoadImageFromUri += loadImageFromUri;
}
Thanks
We store some texts in rtf-format in our database. Now I have to convert them to html.
This is an expample of the rtf-text:
{\rtf1\ansi\ansicpg1252\deff0\deflang2055{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\fs20 Dampf- und Gassperre aus Fl\'fcssigkunststoff f\'fcr D\'e4mmung von K\'e4lteleitungen. Flexible, schwerentflammbare und dampfbremsende Beschichtung auf Wasserbasis. Auch geeignet zum Schutz von l\'f6sungsmittelempfindlichen Isolierstoffenbei K\'e4lte-Isolierungen im Innen- und Aussenbereich.\f1\fs17\par
}
To convert it to html I use the following code:
Telerik.Windows.Documents.Flow.FormatProviders.Rtf.RtfFormatProvider rtfProv = new();
Telerik.Windows.Documents.Flow.Model.RadFlowDocument rtfDoc = rtfProv.Import(rtfInput);
Telerik.Windows.Documents.Flow.FormatProviders.Html.HtmlExportSettings expSettings = new()
{
DocumentExportLevel = Telerik.Windows.Documents.Flow.FormatProviders.Html.DocumentExportLevel.Fragment,
StylesExportMode = Telerik.Windows.Documents.Flow.FormatProviders.Html.StylesExportMode.None,
};
Telerik.Windows.Documents.Flow.FormatProviders.Html.HtmlFormatProvider htmlProv = new()
{
ExportSettings = expSettings
};
string ret = htmlProv.Export(rtfDoc);
return new HtmlString(ret);
<body><p style="margin-bottom: 0px;"><span style="font-size: 13.333333333333334px;">Dampf- und Gassperre aus Flüssigkunststoff für Dämmung von Kälteleitungen. Flexible, schwerentflammbare und dampfbremsende Beschichtung auf Wasserbasis. Auch geeignet zum Schutz von lösungsmittelempfindlichen Isolierstoffenbei Kälte-Isolierungen im Innen- und Aussenbereich.</span></p></body>
Hello,
I have a corrupted XLSX file from CSV dataSource
With other CSV dataSource all is ok
In example in file-attach, I added CSV dataSource with corruption
There are 2 bad lines in generated XLSX file and CSV file have a good format !!!
It's not an issue with codepage or separator !
It's a projet DotNet Core 6 with last version 2023.2.713.20 of API
Do you have encountered this error already ?
Best regards
Cyril REILER
Hi all,
This is a fragment from my code where I use tables in a RadFlowDocument to list some values. This all works fine for me, except one thing: between the text in a cell en the bottom border of that cell is some white space I can't get rid of. I want the bottom border of the cell to have the same distance to the text in the cell as between the text and the top border (border color set to blue for debugging..)
Tried playing with the row Height, cell padding, etc., but that doesn't change anything.
What am I missing?
var doc = new RadFlowDocument();
var tableStyle = new Style("TableStyle", StyleType.Table);
tableStyle.TableProperties.Borders.LocalValue = new TableBorders(new Border(1, BorderStyle.Single, new ThemableColor(Colors.Blue)));
tableStyle.TableProperties.Alignment.LocalValue = Alignment.Left;
tableStyle.TableCellProperties.VerticalAlignment.LocalValue = VerticalAlignment.Top;
tableStyle.TableCellProperties.Padding.LocalValue = new Padding(0, 0, 0, 0);
tableStyle.TableRowProperties.TableCellSpacing.LocalValue = 0;
tableStyle.CharacterProperties.FontSize.LocalValue = 12;
doc.StyleRepository.Add(tableStyle);
var section = new Section(doc)
{
PageMargins = new Padding(50, 50, 50, 50),
PageNumberingSettings =
{
StartingPageNumber = 1,
}
};
doc.Sections.Add(section);
var paragraph = new Paragraph(doc);
section.Blocks.Add(paragraph);
Table table = new Table(doc, 0, 2)// 0 rows, 2 columns.
{
LayoutType = TableLayoutType.FixedWidth,
PreferredWidth = new TableWidthUnit(700),
StyleId = "TableStyle"
};
// add 2 rows with 2 cells
TableRow row = table.Rows.AddTableRow();
TableCell cell = row.Cells.AddTableCell();
cell.PreferredWidth = new TableWidthUnit(100);
paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun($"Cell R1C1");
cell = row.Cells.AddTableCell();
cell.PreferredWidth = new TableWidthUnit(600);
paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun("Cell R1C2");
cell = row.Cells.AddTableCell();
cell.PreferredWidth = new TableWidthUnit(100);
paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun($"Cell R2C1");
cell = row.Cells.AddTableCell();
cell.PreferredWidth = new TableWidthUnit(600);
paragraph = cell.Blocks.AddParagraph();
paragraph.Inlines.AddRun("Cell R2C2");
Kind regards,
Kees Alderliesten
As the title says...