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
Excel Panel List
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Jim Bullis
-
- Senior Member
- Posts: 167
- Joined: Tue, Oct 03 2006, 6:51PM
- Location: Phoenix, AZ
- Contact:
Excel Panel List
Fred Hirsch
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Excel Panel List
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Senior Member
- Posts: 167
- Joined: Tue, Oct 03 2006, 6:51PM
- Location: Phoenix, AZ
- Contact:
Re: Excel Panel List
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
thanks,
Fred
Fred Hirsch
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Excel Panel List
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Excel Panel List
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
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
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Excel Panel List
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
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
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Senior Member
- Posts: 167
- Joined: Tue, Oct 03 2006, 6:51PM
- Location: Phoenix, AZ
- Contact:
Re: Excel Panel List
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
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