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.
Spreadsheet will not Load
Forum rules
and Helpful information
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help
Also, be nice to others! Read the FreeCAD code of conduct!
Also, be nice to others! Read the FreeCAD code of conduct!
Re: Spreadsheet will not Load
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.
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.
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
-
- Veteran
- Posts: 5513
- Joined: Thu Apr 05, 2018 1:53 am
Re: Spreadsheet will not Load
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 wrote: ↑Wed Sep 22, 2021 10:46 pm 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.
Re: Spreadsheet will not Load
Thanks for pointing it out. Corrected my post above (slightly).
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.