Spreadsheet Does Not Exist

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

staraptor78
Posts: 6
Joined: Wed Jul 24, 2019 10:14 am

Spreadsheet Does Not Exist

Postby staraptor78 » Mon Feb 24, 2020 11:45 am

Hi Everyone,

This has been a recurring error when trying to drag spreadsheets into a spreadsheet data reader and trying to select and/or change sheets. I'm also sure that the files are not corrupted and i am still able to edit them from inside the Navigator Panel. Please see attached image for the error.

Error Message Below:

Sheets cannot be read from file ./data-in/*file path here*/myfile.xlsx


Any help would be greatly appreciated.
Attachments
fileerror.png
fileerror.png (7.85 KiB) Viewed 1676 times

darvehng
Posts: 12
Joined: Mon Apr 08, 2019 4:40 pm

Re: Spreadsheet Does Not Exist

Postby darvehng » Wed Mar 18, 2020 4:42 pm

Hi Staraptor78,

Thank you for your inquiry. Please see below to the list of questions that I would greatly appreciate your responses to. Answering these question will help me better assist you. I look forward to hearing from you.

1.) Which version of CloverDX Designer are you using? If you aren't running this graph locally (the one with the "SpreadSheetDataReader"), then what version of CloverDX Server are you using?
2.) Just to confirm, are you receiving this error message when dragging and dropping spreadsheets onto the "SpreadSheetDataReader" component and while also attempting to select sheets from within the "SpreadSheetDataReader"?
3.) Are you receiving this error message with all spreadsheets or only particular spreadsheets (for example the one high-lighted in the error message)?
4.) Regarding the error message, is that the only sub-directory within the data-in directory (DGW) your spreadsheets are contained in? If not, are you also receiving the error message when dragging the spreadsheets from other directories and/or sub-directories in your work-space?


Best Regards,
---
George Darvehn
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

staraptor78
Posts: 6
Joined: Wed Jul 24, 2019 10:14 am

Re: Spreadsheet Does Not Exist

Postby staraptor78 » Tue Apr 21, 2020 3:14 am

Hi Darvehng,

Please see answers below:

1.) Which version of CloverDX Designer are you using? If you aren't running this graph locally (the one with the "SpreadSheetDataReader"), then what version of CloverDX Server are you using?


Currently using the latest version of CloverDX.

2.) Just to confirm, are you receiving this error message when dragging and dropping spreadsheets onto the "SpreadSheetDataReader" component and while also attempting to select sheets from within the "SpreadSheetDataReader"?


Both the drag and drop and selecting the sheet manualy through the datareader gives the aforementioned error.

3.) Are you receiving this error message with all spreadsheets or only particular spreadsheets (for example the one high-lighted in the error message)?


SOme spreadsheets work, some do not. But all of the spreadsheets are not corrupted in any way.

4.) Regarding the error message, is that the only sub-directory within the data-in directory (DGW) your spreadsheets are contained in? If not, are you also receiving the error message when dragging the spreadsheets from other directories and/or sub-directories in your work-space?


Yes DGW is the only folder in the data-in directory, but i've also tried creating a new directory, even a new project, but the error still remains

bartonv
Posts: 145
Joined: Wed May 03, 2017 12:10 pm

Re: Spreadsheet Does Not Exist

Postby bartonv » Wed Jun 03, 2020 12:08 pm

Hi Staraptor78,
I presume that the issue occurs repeatedly for the same files. If my assumption is correct could you provide an example of such an Excel file so that I can test it on my end?
If my assumption is not correct can you confirm that at the time of the graph execution, the files:
  1. are not used by any other program besides CloverDX,
  2. are not moved or modified between the time of assigning the files to the SpreadsheetDataReade component,
  3. can be opened by Microsoft Excel properly.
I also assume that this issue occurs even in the simplest graph (SpreadsheetDataReader -> Trash). If not, kindly attach the graph in the form of a .grf file.

Regards,
---
Vladimir Barton
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

Tanker62
Posts: 6
Joined: Sat Aug 15, 2020 10:48 am

Re: Spreadsheet Does Not Exist

Postby Tanker62 » Thu Aug 27, 2020 4:07 pm

Yes, reading the OP's description of the issue, I was thinking about an access problem due to the fact that another program is using the file as well, it's a common issue, not just for CloverDX, but pretty much for every program that uses spreadsheets, text documents, etc.
Was that problem ever resolved?


cron