Posted 23 August 2018, 10:35 pm EST
Hello,
I need help to fix the issue “Corrupt xml document” that I am getting during open the excel sheet with SpreadsheetGear.
What I am doing :
First i am loading the sheet client side :
function ImportInputFile(filePath) {
var excelUrl = filePath;
var oReq = new XMLHttpRequest();
oReq.open(‘get’, excelUrl, true);
oReq.responseType = ‘blob’;
oReq.onload = function () {
var blob = oReq.response;
inputExcelIO.open(blob, LoadInputSpread, function (message) {
//here is my some other code
});
};
oReq.send(null);
}
Everything is working fine.
- Now I am doing some changes in the file and trying to access the updated file server side as : //* ExcelFilePath - Its the file that I have used client side to load. var fileCollection = Request.Files; var fileName = fileCollection[0]; var filePath = Server.MapPath(ExcelFilePath);
//Creating temprary folder path to save file with new name. string tempFilePath = Guid.NewGuid().ToString() + FileExtension; tempFilePath = TempPath + “/” + tempFilePath; fileName.SaveAs(tempFilePath);
The functionality is still working fine as I can save the updated file with new name in directory.
Now, I have to implement some more functionality and need to access the same file (Old one) and for the same I have applied the code to open the file with spreadsheetgear as : SpreadsheetGear.IWorkbook workbookInput = SpreadsheetGear.Factory.GetWorkbook(filePath); //Used same file on client side also.
The spreadsheetgear method throwing the exception as “corrupt xml document”.
I have tried to open the any other file instead of the file that I have used already then its working fine. It seems its not working because I am trying to access the file that is already in use (client side) but still I need to open this file but I don’t know how it will be possible.
Please provide me the best solution to fix this issue, appreciated.