Issue with protected .xls file

Aspose.Cells Product Family
1

hi there

we have password protected .xls file and want to convert into pdf password protected file.

as we do :

we have function that return as byte[]

start function

workbook = New Aspose.Cells.Workbook

'workbook.Open(Request.PhysicalApplicationPath & strInputFilename)

workbook.Open(strInputFilename, Aspose.Cells.FileFormatType.Excel2003, "007")

'ExceltoPDF(workbook, strOutputFilename)

strFileName = Path.GetFileName(strInputFilename)

strFileName = strFileName.Substring(0, strFileName.LastIndexOf(".")) & ".xml"

workbook.Save(strServerPath & strFileName, Aspose.Cells.FileFormatType.AsposePdf)

pdf.BindXML(strServerPath & strFileName, Nothing)

pdf.Security = New Aspose.Pdf.Security

pdf.Security.UserPassword = "007"

'remove the temporary xml file

File.Delete(strServerPath & strFileName)

Return pdf.GetBuffer()

end function

on pdf.GetBuffer() we get exception : object reference not set to an instance of an object.

help me to find the solution on this issue.

regard

jazz

2

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and check if the issue is with Aspose.Cells component or Aspose.Pdf component and try to resolve it asap.

Thank You & Best Regards,

3

Hi,

I am the developer of Aspose.Pdf responsible for this issue. I have reproduced this problem, and logged it as PDFNET-9607 in our defect database. We will resolve it ASAP. Sorry for inconvenience.

BRs
4

Hi,

We have found the reasons incurring this problem, in order to test it better, could you tell us what you want to do after getting the buffer as byte[], do you want to save it as .pdf file or have other purposes.

BRs

5

yes, we want to save it into table column.

6

Hi,

Could you offer the complete code snippet or example so that we could test it better? Thanks.

BRs

7

we are attaching example so you can understand better. I am also sending excel file for your testing.

password ="007"

Thank in Advance

8

Hi,

The issue has been resolved. Please try the attached dll before we publish our new hotfix. Thanks.

Best regards.

9

hi,

That is working fine. There is one more issue Like. if we want open excel file. After open we want to check it is password protectet or not.

On the base of this we want to do some thing. here is code:

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook();

workbook.Open("c:\\templatefile.xls");

if (workbook.IsProtected)

{

//here goes your code for protected file

}else

{

//here goes your code for not protectet file

}

waiting for your reply

regards

10

Hi,

Well I am afraid Aspose.Cells does not support to check whether the file is open/modify protected. You may only use Workbook.IsProtected to check whether workbook is protected using windows/structure lock options (In MS Excel check menu options Tool--> Protection --> Protect Workbook).

Thank you.

11

Hi,

Please try our latest version v5.1.4:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry265124.aspx
<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<w:DoNotOptimizeForBrowser/>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val=“–”/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

<![endif]–>

We have supported setting encryption and protection settings on the generated pdf file

Sample code:

workbook.Open("test.xls");

PdfSaveOptions saveOption = new PdfSaveOptions();

saveOption.SecurityOptions = new Rendering.PdfSecurity.PdfSecuritySettings();

saveOption.SecurityOptions.UserPassword = "user";

saveOption.SecurityOptions.OwnerPassword = "owner";

saveOption.SecurityOptions.ExtractContentPermission = false;

saveOption.SecurityOptions.PrintPermission = false;

workbook.Save("test.pdf",saveOption);

Thanks!


12

Hi jaswinder,

This reply is only for your kind consideration. Please try our latest version Aspose.Cells v5.1.4:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry265124.aspx

The functionality of setting encryption and protection on pdf is now supported. Sample code is give below to use the settings.

Sample Code:
WorkBook objWb = new WorkBook("test.xls");
PdfSaveOptions saveOption = new PdfSaveOptions();
saveOption.SecurityOptions = new Rendering.PdfSecurity.PdfSecuritySettings();
saveOption.SecurityOptions.UserPassword = "user";
saveOption.SecurityOptions.OwnerPassword = "owner";
saveOption.SecurityOptions.ExtractContentPermission = false;
saveOption.SecurityOptions.PrintPermission = false;
objWb.Save("test.pdf",saveOption);

Thanks,