Convert to PDF into stream

[user001]

I'm trying to convert Excel document to PDF. And when I use file, it works fine:

Code: Select all

var workbook = new Workbook();
workbook.LoadFromFile("file.xlsx");
workbook.SaveToFile("file2.pdf", FileFormat.PDF);


file2.pdf - normal pdf file.

But when I try to save into stream, I get Excel file in this stream:

Code: Select all

var workbook = new Workbook();
workbook.LoadFromFile("file.xlsx");
using (var stream = new MemoryStream())
{
    workbook.SaveToStream(stream, FileFormat.PDF);
    stream.Seek(0, SeekOrigin.Begin);
    File.WriteAllBytes("file3.pdf", stream.ToArray());
}


file3.pdf - Excel file

Why it's happening? How can I get PDF file from workbook in my stream?

Thank You

[amy.zhao]

Hello,

Thanks for your inquiry.
I used Spire.XLS Pack Hotfix Version:7.3.12 to test your code of saving into stream, but it worked fine in my side, I got file3.pdf .
Would you please try the version?

You could also try the below solution.

Code: Select all

  Workbook wb = new Workbook();
            wb.LoadFromFile(@"file.xlsx");
            using (var stream = new MemoryStream())
            {
                wb.SaveToStream(stream, FileFormat.PDF);
                stream.Position = 0;
                File.WriteAllBytes("file3.pdf", stream.ToArray());
            }

Best wishes,
Amy

[user001]

I tested with proposed version and it works fine...
But this issue still present in free version. I tried with Version:7.3.14.

Are you planing to fix it?

Thanks

[amy.zhao]

Hello,

Sorry for the inconvenience caused by the issue in Free version.
I have posted the issue to our dev team. We will inform you when it is fixed.
Feel free to contact us if you have any problems.

Best wishes,
Amy
E-iceblue support team