Spreadsheet will not Load

[rhprice2]

I am attempting to load a spread sheet. The spreadsheet is Excel for the Mac version 16.53. I just downloaded the latest version of FreeCad and the errors duplicate. I just updated the OS and it is current.

The following is the Report View on Load:10:51:16 OpenGL version is: 2.1 (2.1 ATI-4.6.20)
10:51:16 Run Gui init script
10:51:16 Init: Running FreeCADGuiInit.py start script...
10:51:16 Init: Searching modules...
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Mesh... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Draft... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/ReverseEngineering... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Drawing... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Test... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Fem... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Spreadsheet... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Web... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/TechDraw... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Path... done
10:51:16 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/MeshPart... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Show(InitGui.py not found)... ignore
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Sketcher... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Start... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/OpenSCAD... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Surface... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Robot... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Image... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Inspection... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Idf(InitGui.py not found)... ignore
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Arch... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/AddonManager... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Points... done
10:51:17 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Measure(InitGui.py not found)... ignore
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/PartDesign... done
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Tux... done
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Part... done
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Import... done
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Material... done
10:51:18 Init: Initializing /Applications/FreeCAD.app/Contents/Resources/Mod/Raytracing... done
10:51:18 Module: Part
10:51:19 Loading Part module... done
10:51:19 Init: Initializing /Users/rhprice2/Library/Preferences/FreeCAD/Mod/A2plus... done
10:51:19 Init: Initializing /Users/rhprice2/Library/Preferences/FreeCAD/Mod/Assembly4... done
10:51:19 Init: Loading FreeCAD GUI
10:51:19 Init: Running FreeCADGuiInit.py start script... done
10:51:21 Init: Activating default workbench StartWorkbench
10:51:21 Loading GUI of Web module... done
10:51:21 Loading GUI of Start module... done
10:51:21 Loading Start module... done
10:51:21 Init: Showing main window
10:51:21 Main window restored
10:51:21 Show main window
10:51:21 Toolbars restored
10:51:21 3Dconnexion framework not found!
10:51:21 Init: Entering event loop
10:51:21 Init: Processing command line files

I do not know what the 3Dconnexion framework is or even if it is relevant.

When I drag and drop a spreadsheet from Finder into the program I get the following from Report View:

10:58:08 Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/Applications/FreeCAD.app/Contents/Resources/Mod/Spreadsheet/importXLSX.py", line 468, in insert
handleWorkBook(theBook, sheetDict, theDoc)
File "/Applications/FreeCAD.app/Contents/Resources/Mod/Spreadsheet/importXLSX.py", line 409, in handleWorkBook
actSheet.setAlias(adressList[0]+adressList[1], aliasName)
<class 'ValueError'>: Invalid alias

The spreadsheet "Sheet1" was empty. The Excel sheet had some text, numbers, an alias (It was a tester). My first thought was that you cannot drag and drop.

So I used the Import File Icon for the same spread sheet:

11:00:59 Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/Applications/FreeCAD.app/Contents/Resources/Mod/Spreadsheet/importXLSX.py", line 430, in open
handleWorkBook(theBook, sheetDict, theDoc)
File "/Applications/FreeCAD.app/Contents/Resources/Mod/Spreadsheet/importXLSX.py", line 409, in handleWorkBook
actSheet.setAlias(adressList[0]+adressList[1], aliasName)
<class 'ValueError'>: Invalid alias

and the sheet is empty...

Sorry for all the text but I really don't know what is needed to diagnose this problem. My hope is that this is something simple. Any help would be appreciated. Thanks in advance.

[chrisb]

The Import function of the spreadsheet, Menu->Spreadsheet->Import can import only tab separated data. Excel files can be imported via menu->File->Import.

For your next post:
- Please attach your full FreeCAD info as described in the IMPORTANT forum rules linked above.
- put the output in code tags for improved readability.

[TheMarkster]

The Import function of the spreadsheet, Menu->Spreadsheet->Import can import only tab separated data. Excel files can be imported via menu->File->Import.

For your next post:
- Please attach your full FreeCAD info as described in the IMPORTANT forum rules linked above.
- put the output in code tags for improved readability.

https://github.com/FreeCAD/FreeCAD/pull/5059 will allow users to change a user parameter for different delimiter options, such as commas, semicolons, etc.

[chrisb]

Thanks for pointing it out. Corrected my post above (slightly).