Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Aug 04, 2020 2:36 am

HI

I want to print excel worksheet with spire
I found that the following statement can
Code: Select all
sheet.PageSetup.PaperSize = PaperSizeType.PaperA4;

But I want to customize the paper
please help me

ljxlxh2020
 
Posts: 3
Joined: Tue Aug 04, 2020 2:27 am

Tue Aug 04, 2020 7:57 am

Hello,

Thanks for your inquiry.
Our Spire.XLS is based on Microsoft Excel, and Microsoft Excel does not support custom paper size. Sorry we don't support that either.
If there is anything else we can do for you, please feel free to contact us.

Sincerely
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Tue Aug 04, 2020 8:41 am

OK thanks

Maybe I didn't make it right

I've added custom paper to the printer,actually
How do I use it in worksheet pagesetup .
Or How can I get the all PaperSizes in worksheet pagesetup And assign a value to sheet.PageSetup.PaperSize

best

ljxlxh2020
 
Posts: 3
Joined: Tue Aug 04, 2020 2:27 am

Tue Aug 04, 2020 10:19 am

Hello,

Thank you for your feedback.
Sorry we do not support using the printer's custom paper size to set the paper size of the sheet at present. We are considering adding it as a new feature to our upgrade list with the ticket SPIREXLS-2603. If it can be achieved in the future, we will let you know. Sorry for the inconvenience caused.

Sincerely
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Wed Aug 05, 2020 12:45 am

OK thanks
I have great expectations of the update.

ljxlxh2020
 
Posts: 3
Joined: Tue Aug 04, 2020 2:27 am

Wed Aug 05, 2020 2:04 am

Ok, once there is any progress, I will notify you immediately. Have a nice day!

Sincerely
Elena
E-iceblue support team
User avatar

Elena.Zhang
 
Posts: 279
Joined: Thu Jul 23, 2020 1:18 am

Fri Apr 30, 2021 9:10 am

Hello,

Greetings from E-iceblue!
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.4.6 which supports getting printer customized paper size and set it to worksheet, please download it from the following links to test on your side. Looking forward to your test result.
Code: Select all
PageSetup.CustomPaperSizeName

Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.4.6

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Fri May 07, 2021 2:01 am

Hello,

Greetings from E-iceblue!
Does this hotfix solve your issue? Could you please give us some feedback at your convenience?

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Return to Spire.XLS