Questions on Telerik Document Processing Forum

6 answers

2.3K+ views

Hi support,

I'm trying to set the width to 4 columns in a new spreadsheet but it doesn't work the way I expect.

Here's is the code

01.Workbook workbook = new Workbook();

02.Worksheet worksheet = workbook.Worksheets.Add();

03.

04.worksheet.Columns[1].SetWidth(new ColumnWidth(8.11, true));

05.worksheet.Columns[2].SetWidth(new ColumnWidth(33.78, true));

06.worksheet.Columns[3].SetWidth(new ColumnWidth(60.67, true));

07.worksheet.Columns[4].SetWidth(new ColumnWidth(7.67, true));

08.

09.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

10.

11.using (Stream output = new FileStream(fileName, FileMode.Create))

12.{

13. formatProvider.Export(workbook, output);

14.}

When I check the size of each column in the exported file this is what I get:

column 1: 0.63 (10 pixels)
column 2: 4.00 (43 pixels)
column 3: 7.89 (78 pixels)
column 4: 0.63 (10 pixels)

and what I need is:

column 1: 8.11 (80 pixels)
column 2: 33.78 (311 pixels)
column 3: 60.67 (553 pixels)
column 4: 7.67 (76 pixels)

You can see the screenshot I attached.

How can I get the exact size I'm specifying?

Thank you,

PD: I'm using version Telerik 2019.1.114.40

SpreadProcessing

answered on 08 Jul 2020

8 answers

1.3K+ views

Get text from DOCX

Are you able to open a DOCX and return the text from the document into a string. I need to be able to parse through the string to determine text replacements to be made. I can see methods for replacing text, but not for determining what text a document contains

Regards

WordsProcessing

answered on 30 Jun 2020

1 answer

5.5K+ views

Import Data from Excel file

Hello,

Our MVC/Kendo project utilized Telerik.Documents.SpreadsheetStreaming library to export data to Excel file. Now we'd like to do reverse process - IMPORT process which read data from physical location (through file system or from database) to C# object. I didn't find related Interface or method in Telerik.Documents.SpreadsheetStreaming. Could someone point out which library is the better way to do so. Thanks in advance!

SpreadProcessing

answered on 29 Jun 2020

2 answers

684 views

Scaling PDF document

Hi

I'm trying to create report as a PDF file and the report might have several PDF documents as appendixes.

01.

02.RadFixedDocument reportPdf = CreateReportPdf();

03.foreach(RadFixedDocument appendixPdf = appendixes)

04.{

05. // here I would like to scale appendixPdf to 80% of reportPdf.

06. // Then I would like to add some header/footer telling which appendix file that has been added

07. reportPdf.merge(appendixPdf);

08.}

09.return reportPdf;

I hope the above example gives an idea on what I'm trying to do. Hope somebody can give some inspiration on how to accomplish it.

Yours
/peter

PdfProcessing

answered on 12 Jun 2020

6 answers

1.7K+ views

Export to pdf - font styles not exported?

Hi! I'm generating an Excel document containing various fonts of "HelveticaNeue". Please see attached images for samples.

When exporting to pdf using PdfFormatProvider, the font styles are changed, e.g. bold style disappears. However, when exporting using Excel interops it works.

Code using interops:

public static void ExcelToPdf( string xlFilePath, string pdfOutputPath )

{

try

{

Excel.Application app = new Excel.Application();

app.Visible = false;

app.DisplayAlerts = false;

Excel.Workbook wkb = app.Workbooks.Open( xlFilePath, ReadOnly: true );

wkb.ExportAsFixedFormat( Excel.XlFixedFormatType.xlTypePDF, pdfOutputPath );

wkb.Close();

app.Quit();

}

catch ( Exception ex )

{

Console.WriteLine( ex.StackTrace );

throw ex;

}

Code using Telerik PdfFormatProvider:

public override void Generate( DimensionTableInput input )

{

CreateWorkbook();

CreateWorkbookStyles();

CreateWorksheets( input );

XlsxFormatProvider xlsxFormatProvider = new XlsxFormatProvider();

PdfFormatProvider pdfFormatProvider = new PdfFormatProvider();

// this will result in 1 page per sheet

pdfFormatProvider.ExportSettings = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.Export.PdfExportSettings( ExportWhat.EntireWorkbook, true );

string xlsxFileName = $"{input.DocumentTitle}.xlsx";

string xlsxFullPath = $"{ Path.Combine( input.OutputPath, xlsxFileName )}";

ExportToFile( xlsxFormatProvider, xlsxFullPath );

string pdfFileName = $"{input.DocumentTitle}.pdf";

string pdfFullPath = $"{ Path.Combine( input.OutputPath, pdfFileName )}";

ExportToFile( pdfFormatProvider, pdfFullPath );

//Helpers.ExcelHelper.ExcelToPdf( xlsxFullPath, pdfFullPath );

}

private void ExportToFile( IWorkbookFormatProvider formatProvider, string fileName )

{

using ( Stream fs = File.OpenWrite( fileName ) )

{

formatProvider.Export( _workbook, fs );

}

I can share the original Excel and Pdf files if needed.

Thanks in advance,

John

SpreadProcessing

answered on 11 Jun 2020

3 answers

147 views

Workbook Find fails with Object reference not set to an instance of an object.

I need to read the data from an excel file (not formatted) and in order to do this I need to find a cell that contains a specific text.

I am trying to do this

FindOptions options = new FindOptions()

{

FindWhat = "Record",

MatchEntireCellContents = true

};

but it fails with:

System.NullReferenceException: Object reference not set to an instance of an object.
at Telerik.Windows.Documents.Spreadsheet.Utilities.FindAndReplaceHelper.MoreThan(WorksheetCellIndex left, WorksheetCellIndex right, FindBy searchBy)
at Telerik.Windows.Documents.Spreadsheet.Utilities.FindAndReplaceHelper.<>c__DisplayClass3_0.<OrderResults>b__0(FindResult result)
at System.Linq.Enumerable.TakeWhileIterator[TSource](IEnumerable`1 source, Func`2 predicate)+MoveNext()
at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
at Telerik.Windows.Documents.Spreadsheet.Utilities.FindAndReplaceHelper.OrderResults(FindOptions findOptions, IEnumerable`1 findResults)
at Telerik.Windows.Documents.Spreadsheet.Model.Workbook.Find(FindOptions findOptions)

While looking in the code I have discovered that is because the StartCell is null. Where does it say that the StartCell is mandatory? Also why is the StartCell mandatory?

SpreadStreamProcessing

answered on 27 May 2020

2 answers

1.3K+ views

Check if pdf is corrupted

Hi,

Is there a way to check if a pdf file is corrupted using pdfprocessing?

i'm working on a upload pdf file tool and it will be nice to check if the pdf is or not corrupted before upload. I've already check if the file header is pdf but some corrupted files gone thought.

Thanks!!

PdfProcessing

answered on 26 May 2020

5 answers

1.5K+ views

work with fillable pdf forms?

It seems like the api does not have the ability to read and insert values into a pdf fillable form. Will this feature be implemented in the near future? If so, any timeline? Thanks.

PdfProcessing

answered on 21 May 2020

1 answer

347 views

PdfFormatProvider Export

It appears that the PDF export in the dotnet core/standard version is broken. No font data is retained. Instead all fonts are changed to the default font, font weight, and style. The only font property that is retained through conversion is the size. I noticed that there are others complaining about this in the Framework version but I have not seen any progress in fixing the problem or work around suggested. Is there a way to export to PDF a flex document with some control over the font weight and style?

WordsProcessing

answered on 20 May 2020

1 answer

115 views

Export error when there is custom cell editors

Hi,

I'm implementing custom cell editor using spreadprocessing to create a template for user to export and edit. After they are done, they import back using the Telerik built-in import function. I have no problem when creating the validation in the cells as I followed your example here:

https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/custom-editors/defaultcs.aspx

When I tried to open the export file, I would get an error : "We found a problem with some content in "abcd.xlsx". Do you want us to try to recover as much as we can? ..." After I clicked 'Yes', my custom cell editors disappeared.

The same error occurs when I export from your demo. However, if I create a spreadsheet with validation from scratch, everything works perfectly.

Please help!

Thank you,

Helen

SpreadProcessing