Telerik Forums
Telerik Document Processing Forum
2 answers
179 views

Hi, 

I`m playing with Excel export task using SpreadProcessing.

I`ve notice that when i`m using merge for cellSelection - time needed to write to workbook increases dramatically. 

I made simple test -  cycle with 10000 inserts operations and merges of two cells (horizontal merge).

The results for cycle:

- with merge takes 00:00:06.3593555

- without merge takes 00:00:00.1815065

 My code:

var workbook = CreateWorkbook();
 workbook.History.IsEnabled = false;
workbook.SuspendLayoutUpdate();           
var worksheet = workbook.ActiveWorksheet;          
for (int i = 0; i < 10000; i++)
{
    CellIndex cellIndex = new CellIndex(i, 0);
    worksheet.Cells[cellIndex].SetValue("Data " + i);
    worksheet.Cells[cellIndex].SetHorizontalAlignment(RadHorizontalAlignment.Left);
    worksheet.Cells[i, 0, i, 2].MergeAcross();
}
workbook.ResumeLayoutUpdate();
workbook.History.IsEnabled = true;

Although, I made test with merge from 0 to 8 column. Result - 00:00:15.4579052.

Is there any workaround of such perfomance issue? 

 

Ars
Top achievements
Rank 1
 answered on 24 Nov 2015
2 answers
356 views

A web based application, I am working on, must provide users with the ability to export a collection of articles to one single PDF document. This articles contain HTML code for formatting the text as well as positioning of various parts of the article.

Below is the code which I came up with for Exporting one single article:

 

var html = File.OpenText(artPath).ReadToEnd();
var buffer = new byte[0];

var pdfProvider = new PdfFormatProvider();
var htmlFormatProvider = new HtmlFormatProvider();

HtmlImportSettings importSettings = new HtmlImportSettings();
importSettings.UseHtmlHeadingStyles = true;

htmlFormatProvider.ImportSettings = importSettings;

var document = htmlFormatProvider.Import(html);
document.LayoutMode = DocumentLayoutMode.Paged;
document.EnsureDocumentMeasuredAndArranged();

buffer = pdfProvider.Export(document);

using (var fs = new FileStream(pdfDocPath, FileMode.Create, FileAccess.Write, FileShare.Read))
{
fs.Write(buffer, 0, buffer.Length);
fs.Flush();
}

 

However, I am not being able to figure out how to export multiple articles into one single PDF document. Any help would be highly appreciated.

 

Thanks!

Zen

Zen
Top achievements
Rank 1
 answered on 18 Nov 2015
1 answer
140 views

Hi,

I am using RadDocument. When user double clicks on the header section, the caret goes to header section. Is there anyway for me to find out if my caret is in header/footer section or in the document body section?

 

Kind Regards,

 Shahed

 

Todor
Telerik team
 answered on 17 Nov 2015
1 answer
635 views

Is there any way to zip a folder with all sub-folders included?

I can go through each subdirectory and zip its contents - but it doesn't keep the directory structure, and results in all files (from each sub folder) in the one directory

Any help appreciated

 

Michael

Nikolay Demirev
Telerik team
 answered on 13 Nov 2015
1 answer
148 views

Hello,

' The Telerik document processing libraries support .NET Framework versions 4.0 and above. As of Q3 2014 the RadEditor export/import to RTF is not supported under .NET 3.5 '

 

How can I create a Word document with .NET 3.5?

Ianko
Telerik team
 answered on 11 Nov 2015
2 answers
539 views

Hello everybody

 I have a problem with pdf file loading into PdfDocumentSource.

In the OnException handler I have next information:
Value cannot be null.
Parameter name: Pages

   at Telerik.Windows.Documents.Fixed.FormatProviders.Pdf.PdfFormatProvider.Import()
   at Telerik.Windows.Documents.Fixed.PdfDocumentSource.CreateDocumentFromStreamOverride(Stream stream, FormatProviderSettings settings)
   at Telerik.Windows.Documents.Fixed.FixedDocumentStreamSource.CreateDocumentFromStream(Stream stream, FormatProviderSettings settings)

This file is a scan of a document and has one page. I can open it in PDF readers.
Unfortunately ​I can't attach the file because it's confidential (and I don't have such problem with any other file).

Here is it's header and ending:
header:
%PDF-1.3
1 0 obj
<</Type /XObject /Subtype /Image /Name /Im1 /Width 1654 /Height 2338 /Length 315069/ColorSpace /DeviceRGB /BitsPerComponent 8 /Filter [ /DCTDecode ] >> stream

-------------------------------------------------------------------------------------------------------------------------
ending:

endobj
2 0 obj
<< /Length 47 
>>
stream
q 595.44 0 0 841.68 0.00 0.00 cm 1 g /Im1 Do Q
endstream
endobj
3 0 obj
<<
/Type /Page
/MediaBox [0 0 596 842]
/Parent 4 0 R 
/Rotate 0 /Resources <<
/ProcSet [/PDF /ImageC /ImageB /ImageI]
/XObject <<
/Im1 1 0 R
 >>
 >>
/Contents [ 2 0 R
]
>>
endobj
4 0 obj
<<
/Type /Pages
/Kids [ 3 0 R]
/Count 1
>>
endobj
5 0 obj
<<
/Type /Catalog
/Pages 4 0 R  
>>
endobj
6 0 obj
<< /Creator ()
/CreationDate ()
/Author ()
/Producer ()
/Title ()
/Subject ()
>>
endobj
xref
1 7
0000000000 65535 f 
0000000009 00000 n 
0000315262 00000 n 
0000315359 00000 n 
0000315546 00000 n 
0000315604 00000 n 
0000315655 00000 n 
trailer
<<
/Size 7
/Root 5 0 R
/Info 6 0 R
>>
startxref
315751
%%EOF

 

Is there any possibility to load this document source?

 

Thanks,

Dzmitry

Dzmitry
Top achievements
Rank 1
 answered on 06 Nov 2015
1 answer
126 views

Hello, is it possible to add a chart/graph to generated xlsx ?

 

Thank you

Tanya
Telerik team
 answered on 05 Nov 2015
1 answer
299 views

Hi,

Is there a way to set the document's format to landscape ?

I know we can perform this with the RadPdfProcessing but I also need a header and a footer.

 

Actually here is my scenario:

I need to generate a landscape format document including header, footer and dynamically populated grids with business datas, so should I use RadFixedDoucment or RadFlowDocument ?

 

Thanks,

Rémi.

Tanya
Telerik team
 answered on 28 Oct 2015
1 answer
180 views

Hi,

 

 Is it possible to display fleshly created RadFixedDocument in PdfViewer or do I have to save the RadFixedDocument as a file and then bind this file to the PdfViewer ?

I mean doing something like this : 

 

Model:

<telerik:RadPdfViewer Name="pdfViewer" Document="{Binding NewDocument}"  />​

'ViewModel:
NewDocument = CreateDocument()

 

Thanks,

Rémi.

Rémi
Top achievements
Rank 1
 answered on 23 Oct 2015
10 answers
176 views

Hi,

 I have updated our company software to the 2015 Q2 release. According the release history this should include the following for the PDFProcessing.

  • Introduced API for merging PDF documents.
  • Implemented loading ImageSource on demand when importing PDF documents.
  • Introduced API for accessing image data.
  • Implemented support for import and export of TrueType fonts.
  • Implemented support for import and export of text showing content stream operators.
  • Implemented support for import and export of text positioning content stream operators.
  • Optimized performance when Image objects are imported and exported by not decoding and encoding the image data.
  • Provided API for inserting and retrieving images as encoded image data.

Has all the documentation been updated yet as it looks the same as when I last looked. I am disappointed that I am still suffering from the following issues, which I thought would be covered by the above fixes.

  1. Cannot import png files correctly (transparency issues)
  2. Cannot import pdf file to include in generated document (shows as blank page)
  3. Image compression on imported images cannot be turned off (ImageQuality.High causes to much of a loss of quality for printed documents)

Is it still the case that the above problems are still unfixable for now?

Regards,

 

Shaun

 

Deyan
Telerik team
 answered on 23 Oct 2015
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?