Excel to Pdf Conversion

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Excel to Pdf Conversion

Postby araafathmd » Tue Mar 19, 2013 1:03 pm

Hi ,

Kindly give me the code sample for excel to pdf conversion using Spire.Xls.

i wanted to show one sheet per page in pdf irrespective of no of fields in excel sheet.

for example if the single sheet has 150 fields , the converted file needs to show those 150 fields of sheet in single pdf page.

i couldnt able to upload the xlsx, xls in this topic .

so please create some sample excel file with more than 100 fields and do the conversion process.

kindly provide the sample code for the same.

based on the output , i can go for purchase the same by convincing my managements .

Already there is talk is happening for word to pdf conversion , i wanted to done the excel to pdf using same spire DLL

reply me ASAP

Regards,
Arafath
araafathmd
 
Posts: 3
Joined: Mon Mar 18, 2013 1:38 pm

Re: Excel to Pdf Conversion

Postby amy.zhao » Wed Mar 20, 2013 5:34 am

Dear Arafath,

Thanks for your inquiry.
We also received this issue from your e-mail. Please try the code snippet below to implement it.
Code: Select all

            byte[] data = File.ReadAllBytes(excelfile);
            using (MemoryStream stream = new MemoryStream(data))
            {
                using (Workbook wb = new Workbook())
                {
                    wb.LoadFromStream(stream, ExcelVersion.Version2010);
                    foreach (Worksheet sheet in wb.Worksheets)
                    {
                        if (sheet.Columns.Count() ==0)
                        { continue; }

                        int lastColumn = sheet.LastColumn;
                        int lastRow = sheet.LastRow;
                        while (lastColumn > 0)
                        {
                            CellRange range = sheet.Range[1, lastColumn, lastRow, lastColumn];
                            if (range.IsBlank)
                            {
                                lastColumn--;
                                sheet.SetLastColumn(lastColumn);
                                continue;
                            }
                            else
                            {
                                sheet.AutoFitColumn(lastColumn);
                                break;
                            }
                        }
                    }
                    using (var cvt = new Spire.Xls.Converter.PdfConverter(wb))
                    {
                        using (PdfDocument doc = cvt.Convert(new PdfConverterSettings
                        {
                            FitSheetToOnePage = FitToPageType.NoScale
                        }))
                        {
                            doc.SaveToFile("TestExcelToPDF.pdf");
                        }
                    }
                   
                }
            }
            System.Diagnostics.Process.Start("TestExcelToPDF.pdf");


If you still have this issue or any other issue, please tell us.

Best Regards,
AmyE
E-iceblue support team
User avatar
amy.zhao
 
Posts: 2225
Joined: Wed Jun 27, 2012 8:50 am

Re: Excel to Pdf Conversion

Postby anggunperpatih18 » Mon Apr 29, 2013 2:06 pm

this command
Spire.Pdf.PdfDocument doc = cvt.Convert(new Spire.Xls.Converter.PdfConverterSettings { FitSheetToOnePage = Spire.Xls.Converter.FitToPageType.NoScale });

return error "Specified argument was out of the range of valid values.
Parameter name: FirstRow"

can u help me
anggunperpatih18
 
Posts: 2
Joined: Mon Apr 29, 2013 7:50 am

Re: Excel to Pdf Conversion

Postby Gary.zhang » Tue Apr 30, 2013 3:56 am

Hello anggunperpatih18,

Thanks for your inquiry.
The issue has not been reproduced, could you please provide us your excel file if convenience so that we can repro it and figure out the solution for you.

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team
User avatar
Gary.zhang
 
Posts: 1377
Joined: Thu Apr 04, 2013 1:30 am

Re: Excel to Pdf Conversion

Postby Gary.zhang » Thu May 02, 2013 9:17 am

Hello anggunperpatih18,

Has the issue been resolved? Could you please provide us your excel file if convenience so that we can repro it and figure out the solution for you.

If there are any questions, welcome to get it back to us.

Thanks,
Gary
E-iceblue support team
User avatar
Gary.zhang
 
Posts: 1377
Joined: Thu Apr 04, 2013 1:30 am

Re: Excel to Pdf Conversion

Postby TheHult » Wed Oct 02, 2013 3:34 pm

amy.zhao wrote:Dear Arafath,

Thanks for your inquiry.
We also received this issue from your e-mail. Please try the code snippet below to implement it.
Code: Select all

            byte[] data = File.ReadAllBytes(excelfile);
            using (MemoryStream stream = new MemoryStream(data))
            {
                using (Workbook wb = new Workbook())
                {
                    wb.LoadFromStream(stream, ExcelVersion.Version2010);
                    foreach (Worksheet sheet in wb.Worksheets)
                    {
                        if (sheet.Columns.Count() ==0)
                        { continue; }

                        int lastColumn = sheet.LastColumn;
                        int lastRow = sheet.LastRow;
                        while (lastColumn > 0)
                        {
                            CellRange range = sheet.Range[1, lastColumn, lastRow, lastColumn];
                            if (range.IsBlank)
                            {
                                lastColumn--;
                                sheet.SetLastColumn(lastColumn);
                                continue;
                            }
                            else
                            {
                                sheet.AutoFitColumn(lastColumn);
                                break;
                            }
                        }
                    }
                    using (var cvt = new Spire.Xls.Converter.PdfConverter(wb))
                    {
                        using (PdfDocument doc = cvt.Convert(new PdfConverterSettings
                        {
                            FitSheetToOnePage = FitToPageType.NoScale
                        }))
                        {
                            doc.SaveToFile("TestExcelToPDF.pdf");
                        }
                    }
                   
                }
            }
            System.Diagnostics.Process.Start("TestExcelToPDF.pdf");


If you still have this issue or any other issue, please tell us.

Best Regards,
AmyE
E-iceblue support team


thanks this helped a lot!!!!!

Ive been having to use 3rd party and the pdf never opens
but after some fiddling with this code on spire im really converting them now and super fast :)

regards jon
TheHult
 
Posts: 1
Joined: Wed Oct 02, 2013 3:29 pm

Re: Excel to Pdf Conversion

Postby harry.support » Fri Oct 04, 2013 6:00 am

TheHult wrote:
amy.zhao wrote:Dear Arafath,

Thanks for your inquiry.
We also received this issue from your e-mail. Please try the code snippet below to implement it.
Code: Select all

            byte[] data = File.ReadAllBytes(excelfile);
            using (MemoryStream stream = new MemoryStream(data))
            {
                using (Workbook wb = new Workbook())
                {
                    wb.LoadFromStream(stream, ExcelVersion.Version2010);
                    foreach (Worksheet sheet in wb.Worksheets)
                    {
                        if (sheet.Columns.Count() ==0)
                        { continue; }

                        int lastColumn = sheet.LastColumn;
                        int lastRow = sheet.LastRow;
                        while (lastColumn > 0)
                        {
                            CellRange range = sheet.Range[1, lastColumn, lastRow, lastColumn];
                            if (range.IsBlank)
                            {
                                lastColumn--;
                                sheet.SetLastColumn(lastColumn);
                                continue;
                            }
                            else
                            {
                                sheet.AutoFitColumn(lastColumn);
                                break;
                            }
                        }
                    }
                    using (var cvt = new Spire.Xls.Converter.PdfConverter(wb))
                    {
                        using (PdfDocument doc = cvt.Convert(new PdfConverterSettings
                        {
                            FitSheetToOnePage = FitToPageType.NoScale
                        }))
                        {
                            doc.SaveToFile("TestExcelToPDF.pdf");
                        }
                    }
                   
                }
            }
            System.Diagnostics.Process.Start("TestExcelToPDF.pdf");


If you still have this issue or any other issue, please tell us.

Best Regards,
AmyE
E-iceblue support team


thanks this helped a lot!!!!!

Ive been having to use 3rd party and the pdf never opens
but after some fiddling with this code on spire im really converting them now and super fast :)

regards jon

You are welcome and we are so glad that our solution is helpful. If you have any question, please feel free to tell us.
Harry
Technical Support / Developer,
e-iceblue Support Team
User avatar
harry.support
 
Posts: 180
Joined: Mon Nov 08, 2010 3:11 pm

Re: Excel to Pdf Conversion

Postby Donna111 » Fri Nov 01, 2013 2:51 am

Hi there
I have encountered the same question with you recently.I usually convert pdf files using a pdf processing program.But it can not convert excel to pdf files.It can only convert pdf to png or some other image formats.So i want to get a new pdf converter.It's difficult for me to covnert pdf files using a code.Is there any method which can convert pdf directly?Thanks a lot.
Donna111
 
Posts: 1
Joined: Fri Nov 01, 2013 2:42 am

Re: Excel to Pdf Conversion

Postby amy.zhao » Fri Nov 01, 2013 6:29 am

Hello,

Thanks for your inquiry.
Our Spire.PDFConverter can meet your need. It just is a converter tool without writing code. It can convert popular files to PDF format. It includes converting Excel to PDF, Word to PDF, HTML to PDF, Text to PDF and Images to PDF.
Welcome to download and test Spire.PDFConverter.
Downloading link: http://www.e-iceblue.com/Download/downl ... r-now.html

Please write to us freely if you have further inquiry.

Best regards,
Amy
E-iceblue support team
User avatar
amy.zhao
 
Posts: 2225
Joined: Wed Jun 27, 2012 8:50 am

Re: Excel to Pdf Conversion

Postby amy.zhao » Thu Nov 07, 2013 10:10 am

Hello,

Did you test Spire.PDFConverter? How did it work?

Thanks for your feedback.

Best regards,
Amy
E-iceblue support team
User avatar
amy.zhao
 
Posts: 2225
Joined: Wed Jun 27, 2012 8:50 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests