Uanble to read file

Received : 2007/07/20 06:52:20
Message : Hi,
I am trying to read an excel file and change a field value. While compiling the code there is no error but while trying to open the excel file it is giving the error "Unable to open file".
Please let me know how to resolve this issue.


This message was posted using Aspose.Live 2 Forum

Hi,

Are you using Aspose.Cells for java and which version?

Kindly describe the complete exception here and do post your excel file here, so that we may check and resolve your issue soon.

Thank you.

Hi,

I am using Aspose.Cells for Java version 4.3.0.0.

While I am trying to open the generated file it is giving the error "Unable to read file". Moreover, when the newer excel is generated by Aspose.Cells the size is becoming less than the original.

I am not able to upload the file for your reference. It is too big. It has many calculations in the backend in VB to generate differenty kinds of graphs automatically. Moreover, it has some drop downs and depending on the values of the drop-down the tables will be populated.

Please let me know how to solve this problem.

Could you please trim your file to figure out the root of problem? Without your file, we don't have clues about it.

Hi,

I am attaching the file as well as the code.

package com.novartis.ExcelExample;

import java.io.FileInputStream;
import java.io.IOException;

import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.Worksheets;

public class Main1 {
public static void main(String[] args) throws IOException {
Workbook workbook = new Workbook();
FileInputStream fis = new FileInputStream("C:\\Marketing Mix Documents\\Mmix Platform-Tool.xls");
workbook.open(fis);
Worksheets worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.getSheet("wksSalesInfo");
Cells cells = worksheet.getCells();
Cell cell = cells.getCell("B13");
cell.setValue("Sales Info Sayan");
workbook.save("C:\\Marketing Mix Documents\\Book1.xls");
}
}

Please let me know.

Thanks and regards,

Mridul Paul

Hi Mridul Paul,

Thanks for the template file,

Yes, we reproduced the problem with your template file.

We will figure out your issue soon.

Thank you.

Hi Mridul Paul,

Please try this fix.

Hi Warren,

This working fine now.

Thanks and regards,

Mridul Paul