We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Old protected view excel 2 file

Hi Support,

We have a old protected view excel file, can your api able to read it, we have tried your api(aspose-cells-7.6.1.jar) and its working fine with regular file but same code is not working with protected view excel file.

Code sample:

import java.io.FileInputStream;


import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;


public class AsposeReadExcel {

public static void main(String[] args) {
try {
// Creating a file stream containing the Excel file to be opened
FileInputStream fstream = new FileInputStream(“C:\data\Sample.xls”);
System.out.println(“checkpoint1” );

// Instantiating a Workbook object
Workbook workbook = new Workbook(fstream);
System.out.println(“checkpoint2” );
// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
System.out.println(“checkpoint3” );
// Exporting the contents of 7 rows and 2 columns starting from 1st
// cell to Array.
Object dataTable[][] = worksheet.getCells().exportArray(0, 0, 7, 2);

System.out.println(“output” + worksheet.getCells().exportArray(0, 0, 7, 2));
// Closing the file stream to free all resources
fstream.close();
} catch (Exception e) {
// TODO: handle exception
}

}
}


-Manish

Hi Manish,


Thank you for contacting Aspose support.

As you are using an old version of the API, we would request you to give a try to the latest build of Aspose.Cells for Java 8.2.1. In case the problem persists, please provide us the problematic sample for our review. We will quickly look into your sample to suggest a solution or workaround for your situation. If the presented behavior is established as a bug on the part of Aspose.Cells API, we can log appropriate ticket(s) for correction purposes.