mediamodel url not working after updating existing media(excel file)

[Former Member]

Hi I was reading an excel file form media ,which is uploaded through storefront and stored in media. After reading that file based on my requirement i was adding new columns(like error logs) in existing excel file.After that I was accessing that mediaurl using media model.getURL to download ,but its not working and download started and getting cancelled after few seconds.

 final File excel = new File(filePath);
         final FileInputStream file = new FileInputStream(excel);
 
         //    final FileInputStream file = new FileInputStream(new File(filePath));
         final XSSFWorkbook workbook = new XSSFWorkbook(file);
 
         // Get first sheet from the workbook
         final XSSFSheet abMappingSheet = workbook.getSheetAt(0);
 for (final HashMap.Entry entry : errorData.entrySet())
         {
             final int cellNo = abMappingSheet.getRow(cellCount + 2).getLastCellNum();
             final XSSFCell errorCell = abMappingSheet.getRow(cellCount + 2).createCell(cellNo);
             errorCell.setCellValue(entry.getKey() + "=" + entry.getValue());
             cellCount++;
         }
     final FileOutputStream outFile = new FileOutputStream(excel, false);
         workbook.write(outFile);
         outFile.close();
         workbook.close();
         file.close();

[arvind-kumar_avinash]

Please swap the order of workbook.close() and outFile.close() and see if it works.

 workbook.close();
 outFile.close();

Also, you are using new FileOutputStream(excel, false) whereas I understood from your requirement that you wanted to open as new FileOutputStream(excel, true) i.e. append=`true`

[arvind-kumar_avinash]

Hi @Mani - did it help?

[Former Member]

Actually i tried by swaping and giving true in new FileOutputStream(excel, true) now file is getting downloaded but changes were not reflected(i.e addition of error logs in excel). Whatever I uploaded that one only was downloading

[arvind-kumar_avinash]

Great.

In order to analyze the problem further, I would check the following things in debug mode:

1. The value of entry.getKey() + "=" + entry.getValue() (i.e. the value that you are setting into errorCell )

2. The cell no. you are writing into i.e. the value of cellNo. Please note that getLastCellNum() gives the index_of_the_last_cell +1 of the specified row.

3. The value of cellCount. Why are you using getRow(cellCount + 2)? Shouldn't it be getRow(rowCount + 2)?

[Former Member]

here my problem is not writing data into file i was able to write excel but after updating when try to download file from mediamodel.geturl() that download is starting and getting cancelled, but when i go to backoffice into media and try to download the file i was able to . Except through media url , if i didnt update the file and download the excel direcly that url was working fine.

[Former Member]

Can you please specify what data filePath attributes holds? Is it media URL? I am getting exception when using above code.

final FileInputStream file=new FileInputStream(excel);

I am getting FileNotFoundException . Could you please help me with this query