Excel Panel List

Discuss Thermwood 3-axis Machinery, Controller, and Software.

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Rich Kasten

FredHirsch
Senior Member
Posts: 167
Joined: Tue, Oct 03 2006, 6:51PM
Location: Phoenix, AZ
Contact:

Excel Panel List

Postby FredHirsch » Wed, Feb 26 2014, 6:16PM

Anyone out there willing to share their excel panel list import file? I'm having a hard time getting this to run. Keep getting "file is not in expected format" errors.
thanks,
Fred
Fred Hirsch

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Excel Panel List

Postby Scott Marshburn » Wed, Feb 26 2014, 6:51PM

You need to save the file as a Excel 97-2003 workbook. You can select this when you select save as then in the drop down menu select Excel 97-3003 Workbook.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

FredHirsch
Senior Member
Posts: 167
Joined: Tue, Oct 03 2006, 6:51PM
Location: Phoenix, AZ
Contact:

Re: Excel Panel List

Postby FredHirsch » Wed, Feb 26 2014, 7:02PM

Scott, Thanks for the quick reply. I'm working in Open Office and I don't have that option. Do you have a sample file I can make sure my formatting is correct?
thanks,
Fred
Fred Hirsch

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Excel Panel List

Postby Scott Marshburn » Wed, Feb 26 2014, 7:54PM

I am not familiar with Oppen Office but the layout of the spread sheet should be the same as that is shown in the help menu at the machine for importing excel files. If open Office does not have the ability to save the doc. As an excel file I do not think it will import to the machine. although I could be mistaking.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Excel Panel List

Postby Scott Marshburn » Fri, Feb 28 2014, 7:17PM

Hi Fred I did some research on converting open office to an excel format see this link
There is one other thing you could try. Click on save as and in the file name type for example "myFileName.xls" use The " around the file name. I don't know if this will work in open office or not but I do Know it will work in other programs such as Note Pad.
http://www.ehow.com/how_5112167_convert ... excel.html
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Excel Panel List

Postby Scott Marshburn » Sat, Mar 01 2014, 6:25AM

Upon further investigation I think that all you have to do is. Click on save as and then select The Excel 97/2000/XP(.xls) from the drop down menu.
From what I under stand OppenOffice will not save as current excel versions like .xlxs. But if you are sending the file to the machine it has to be a .xls file anyhow
Also I have found from my experience that there cannot be any formulas in the file either. I have tried and I get a numeric overload error when doing so

See attached screen shot of the format that we use
Attachments
ExcelSpreadSheetFormatForControlNesting.png
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

FredHirsch
Senior Member
Posts: 167
Joined: Tue, Oct 03 2006, 6:51PM
Location: Phoenix, AZ
Contact:

Re: Excel Panel List

Postby FredHirsch » Tue, Mar 04 2014, 12:29PM

Scott,
Thanks for all your help. I'm still struggling to get the machine to take the file. I'll get it... Thanks for your help.
Fred
Fred Hirsch


Return to “Thermwood 3-Axis Machinery”

Who is online

Users browsing this forum: No registered users and 3 guests