Export to REAL Excel

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal

Jon Forsgren
Junior Member
Posts: 67
Joined: Wed, May 18 2005, 9:12AM
Location: Camano Island, WA

Export to REAL Excel

Postby Jon Forsgren » Wed, Feb 15 2017, 7:04PM

Is there a way to export the cut list to full version of Excel? I tried, but it won't happen. Since my door supplier has a 2 sq. ft. min. on doors/drawers fronts, I wanted to export and use a formula to get actual size and then add another foot if needed.

Thanks, Jon

Rick Deskins
Thermwood Team
Posts: 828
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: Export to REAL Excel

Postby Rick Deskins » Thu, Feb 16 2017, 8:10AM

There is a link at the top of the cutlist. (Export Cutlist To Excel) It open an excel file located at C:\Users\Public\Documents\Thermwood\eCabinet Systems\temp\cutlist.xls
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900

Jon Forsgren
Junior Member
Posts: 67
Joined: Wed, May 18 2005, 9:12AM
Location: Camano Island, WA

Re: Export to REAL Excel

Postby Jon Forsgren » Thu, Feb 16 2017, 3:22PM

Thanks for the come-back. That worked fine so far. Only problem now is that all dimensions are Text! Trying to do a formula, but have to go to each measurement and delete quotes. Anyway around this? Tried formatting cells, etc. No good.

Thanks, Jon

Rick Deskins
Thermwood Team
Posts: 828
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: Export to REAL Excel

Postby Rick Deskins » Thu, Feb 16 2017, 3:35PM

You can do a find and replace. Find " and replace it with nothing. Some people write excel macros to manipulate the data. Scott Marshburn is a good resource on working with the cut list and excel. I think he has some videos on youtube. You may search this forum and find some of his work.
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900

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: Export to REAL Excel

Postby Scott Marshburn » Thu, Feb 16 2017, 4:34PM

Hi, Jon. here's a couple of videos that might help you.
https://www.youtube.com/watch?v=jfalIKP ... A&index=32
https://www.youtube.com/watch?v=AAQDq4Q ... A&index=31
I hope this helps.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Jon Forsgren
Junior Member
Posts: 67
Joined: Wed, May 18 2005, 9:12AM
Location: Camano Island, WA

Re: Export to REAL Excel

Postby Jon Forsgren » Thu, Feb 16 2017, 5:01PM

Bada-Bing!


Return to “eCabinet Systems Software”

Who is online

Users browsing this forum: No registered users and 9 guests