Dear sir

When using Korean fonts, the text length is cut off. (Style problem)

There is no problem when using other products.

Is there a solution?

 [telerik]

  [Good]

I'm trying to programmatically create a spreadsheet from some data.  The spreadsheet I'm modelling has Excel filters at the top.  I've seen many different kinds of filters in the Kendo Document processing APIs, however it doesn't appear that any of them function like the default filter in Excel.  Is there a way to add this to my header cell and let Excel fill it in when the sheet is loaded?

Sample

Sample of what Excel shows when you click the filter button.

Mine (so far)

Hello All, 
I am using Telerik.Documents.SpreadsheetStreaming assembly with Version 2020.3.1019.20. I just need how to assign text having hyperlink to ICellExporter object here. Please suggest me if there is any wrong here.

string policy = "<a href=\"https://www.termsfeed.com/blog/sample-terms-and-conditions-template/\">Policy Terms</a>";
string showText = "For necessary info, Please refer " + policy;
//rowExporter -> IRowExporter object here
using var cellExporter = rowExporter.CreateCellExporter();
cellExporter.SetValue(showText);

Thanks

Sam

Hello,

I have below code block to add Hyperlink(IWorksheetExporter) in cell text. But it's not working in the exported file. Please help me to resolve this. 

using var worksheetExporter = workBookExporter.CreateWorksheetExporter("Terms");
            using (var rowExporter = worksheetExporter.CreateRowExporter())
            {
                string conditions = "<a href=http://telerik.com> Terms&Conditions</a>";
                string desc = "Further info, refer " + conditions;
                using var cellExporter = rowExporter.CreateCellExporter();
                cellExporter.SetValue(desc);
            }

Thanks,

Satish 

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?
 

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

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.

Used with Blazor, anyway we can get rid of this warning?

Telerik.Documents.SpreadsheetStreaming 2022.2.613 requires Telerik.Zip (= 2022.2.613) but version Telerik.Zip 2022.3.906 was resolved