logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
siobhan  
#1 Posted : Tuesday, July 3, 2018 12:22:21 PM(UTC)
siobhan

Rank: Member

Groups: Registered
Joined: 6/5/2014(UTC)
Posts: 23
Ireland
Location: Dublin

Thanks: 1 times
Hi

I want to add a password to my excel output report.

Is this possible? I know I can do it for the PDF output in the

View Parameters -> PDF Configuration -> Security Options

Thank You
Siobhan
epf  
#2 Posted : Wednesday, July 4, 2018 7:48:14 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Yes, having a quick look at http://www.winnovative-s...al/ExcelLibUserGuide.htm chapter 4.14

it seems that is works only for Excel 2003 Format, here is the piece of code to do it:
Code:
converter.Book = new ExcelWorkbook(ExcelWorkbookFormat.Xls_2003);
converter.Book.DocumentSecurity.OpenWorkbookPassword = "my Open Password";
converter.Book.DocumentSecurity.WriteWorkbookPassword = "my Write Password";
siobhan  
#3 Posted : Wednesday, July 4, 2018 9:06:52 AM(UTC)
siobhan

Rank: Member

Groups: Registered
Joined: 6/5/2014(UTC)
Posts: 23
Ireland
Location: Dublin

Thanks: 1 times
Hi epf

Thank you for this response, I'm delighted this is a possibility.

Do I add this code to the 'Use Custom configuration text' or the 'Use Custom Template text'

Thank,
Siobhan
epf  
#4 Posted : Wednesday, July 4, 2018 11:07:05 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
No, this is part of the Excel Converter.
Select your Main View, then Excel Configuration -> Root Script: Main
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.