We currently have the ability to export a data table here:
https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/formats-and-conversion/data-table/using-data-table-format-provider
Is there a way to export a data set?
 

Dear Telerik Team,

We encounter an issue with export html data to pdf file using below code. For example,

using Telerik.Web.UI;

using OpenXmlSpreadsheet = DocumentFormat.OpenXml.Spreadsheet;
using Pdf = Telerik.Windows.Documents.Flow.FormatProviders.Pdf;
using te = Telerik.Windows.Documents.Flow.FormatProviders.Html;
using tm = Telerik.Windows.Documents.Flow.Model;
using tp = Telerik.Windows.Documents.Primitives;
using tt = Telerik.Windows.Documents.Spreadsheet.Theming;te.HtmlFormatProvider provider = new te.HtmlFormatProvider();

tm.RadFlowDocument document = provider.Import(HttpUtility.HtmlDecode(htmldata));
tt.ThemeFontScheme fs = new tt.ThemeFontScheme("Arial", "Helvetica", "sans-serif");
tt.DocumentTheme theme = new tt.DocumentTheme("PDF", document.Theme.ColorScheme, fs);
document.Theme = theme;
document.Sections[0].PageMargins = new tp.Padding(50, 25, 50, 25);
Pdf.PdfFormatProvider providerPdf = new Pdf.PdfFormatProvider();
byte[] fileBytes = providerPdf.Export(document);

"providerPdf.Export(document);" this line throws exception "An exception occurred during a WebClient request" whenever we include <img src="/image path/image.png" /> html tag.

Your support is appreciated.

Please try wps application to open docx file that generated by telerik document processing.    www.wps.cn

header and footer are not displayed .

file was generated by ASP.NET Core WordsProcessing Key Features Demo | Telerik UI for ASP.NET Core

I am trying to use Telerik document processing to append some text to an existing pdf document. The text is in Arabic language, that is,  it is Unicode and it has  right to left direction. The resulted pdf document does not show the text even though I can it render the text if I changed the text to  English.

Does Telerik pdf document processing library support Arabic text?

Hi,

I'm using IWorksheetExporter (Telerik.Documents.SpreadsheetStreaming library)  to create big Excel files, ~400 mb xlsx.

I need to add notes to header cells like what is available here https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/notes but it doesn't look to be available in the Streaming library.

I see two possible workarounds.

1. Create my header row with RadSpreadProcessing and reopen the same file for the batch processing with the streaming dll. But I can't find how to append to a worksheet, the only thing that looks like appendable to an existing file is new worksheet.
2. Create the big file with the streaming library and reopen it with RadSpreadProcessing to add the notes. What will be the performance hit to do that? Does opening an excel file load everything in memory? So saving it back will also recreate the whole file?
3. Do you have another solution

NB. Trying to completely create this file via the RadSpreadProcessing library throw a "Stream was too long" from within the library while saving it.

NB. I'm using the latest version from the nuget stream.

Thanks

I have installed the necessary nuget packages for pdf processing in an exisiting Asp.Net Core (.Net 7.0) Blazor project.

- Telerik.Windows.Documents.Core 2023.1.104
- Telerik.Windows.Documents.Fixed 2023.1.104
- Telerik.Windows.Zip 2023.1.104

In the OnClick handler of a button, the first line of code throws an exception:                   

       public void EditPdfDocument(MouseEventArgs args)
        {
            var provider = new PdfFormatProvider(); // exception is thrown here
            var doc = provider.Import(File.ReadAllBytes(@"path-to-file.pdf"));

            // ...
        }

Exception details:

System.TypeLoadException
  HResult=0x80131522
  Message=Could not load type 'System.Windows.Rect' from assembly 'WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
  Source=Telerik.Windows.Documents.Fixed
  StackTrace:
   at Telerik.Windows.Documents.Fixed.FormatProviders.Pdf.PdfFormatProvider..ctor()
  ...

Hello,

I would like to know how can i rotate a given pdf document using Telerik Document Processing Library.

Thank you

Hi,

Is there a way using the Telerik SpreadProcessing library to manipulate the external references in an Excel file?

eg change the source to another file?

thx in advance!

How can I format a set of ranges in a worksheet as a table using document processing?

I couldn't find any source to this matter.

I have attached a screenshot of the Excel function is needed to the desired result.

Hi there,

I am using the trial version at the moment to see if Telerik's document processing can replace another library we are currently using.

Here is our scenario,

We have a Word template document that has merge fields already setup and tables with borders already setup. This word template is read from a database table column into a memory stream and then we use the DocxFormatProvider to import the document to the RadFlowDocument. Below you can see a piece of the template document already setup.

When using EnumerateChildrenOfType<Table>().ElementAt(1) for example I can see that the table is selected and I can see that the border values have been picked up from the word template document. Below inspecting object for the table selected from the template document.

We then perform our mail merge and then use PdfFormatProvider to convert the merge result into a PDF document. The result is that the mail merge fields are merged correctly but all the tables have lost there borders that the original word template document had.

I have tried to after using EnumerateChildrenOfType<Table>().ElementAt(1)  to set the border again manually with new TableBorders(new Border(2, Telerik.Windows.Documents.Flow.Model.Styles.BorderStyle.Dotted, new ThemableColor(Colors.Black))); This also does not work.

Here is the PDF result produced, any suggestions would be appreciated. (Also a note, even if I take out mail merge in the process, the document converting straight from Word Template to PDF still produces the tables with no borders...)

Another note when I use your demo link and load my template and export to PDF the borders are also missing. (Telerik Export to PDF)