Hi Dears,
I'm testing the forge 'Excel Package' component, starting by opening an excel spreadsheet with the Workbook_Open action. But I get the error Could not find a part of the path 'filename'. Any suggestions to resolve ?
Thanks,
Roberto
Hi Chandra and Siya,
I don't think that's the case, because my file only has 3 lines. But I solved the issue by reading the binary file using Workbook_Open_BinaryData instead of WorkBook_Open.
Thank by attention,
Basically WorkBook_Open expects a file that is present in the server file system. Is it the case that you were invoking WorkBook_Open with a file name ( which do not present in the server file systems) you were getting this error and now you are calling the Workbook_Open_BinaryData with the binary data which is stored in the entity ?
Hi,
can you please check What is the row count of your Excel file? . if high then try with 500 row.
Thanks
CV
It looks like you are processing a large excel file and behind the scene the components may attempt to deflate or extract to a temporary folder. Since the file is too large there may be some folder restrictions or resource constraint and hence the file is not created in the temporary folder resulting in this error. As suggested by @Chandra Vikas please try with a small excel file and see it works . A similar issue has been discussed here.