[Si...] Posted November 7, 2018 Share Posted November 7, 2018 Hi, Is there a way to export a result or the data to excel? How would I go about doing so? Thanks. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/ Share on other sites More sharing options...
[Cl...] Posted November 7, 2018 Share Posted November 7, 2018 Resources - define printout - Default Printout/Warning Limit tab. Open excel report (at bottom) If you want I'll send you a video clip that shows you how to customize the spreadsheet. E-mail me, and I'll replay back with the video clip attached. cgilbert@autocam-medical.com Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112784 Share on other sites More sharing options...
[De...] Posted November 7, 2018 Share Posted November 7, 2018 Go to Resources -> Define Printout In the dialog window that come up choose the Default printout / Warning Limit tab. Click the File folder icon next to te Excel Report field and choose Report.ini (You can create a copy and modify it if you want and call it whatever you want - just point this at wherever you put your custom version) Next, on the start measurement dialog box when you go to run the program, check the excel printout checkbox. This should create an excel spreadsheet with results for all of your characteristics. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112786 Share on other sites More sharing options...
[Si...] Posted November 7, 2018 Author Share Posted November 7, 2018 Ok, So I did this.. I run the program but Excel opens and everything is blank and greyed out... What did I miss? Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112788 Share on other sites More sharing options...
[De...] Posted November 7, 2018 Share Posted November 7, 2018 Under Resources -> Results to file make sure Table File is set to on. I think thats probably necessary for it to give results. Sorry, forgot that part. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112790 Share on other sites More sharing options...
[Si...] Posted November 7, 2018 Author Share Posted November 7, 2018 I turned on Table file now, Still same results. Do I turn on Merge file as that becomes available when I turn on the Table File. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112792 Share on other sites More sharing options...
[Ma...] Posted November 7, 2018 Share Posted November 7, 2018 Here is something I put together for a customer Mark Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112794 Share on other sites More sharing options...
[De...] Posted November 7, 2018 Share Posted November 7, 2018 Guess I was wrong about the table file being necessary based on Mark's presentation, I am really not sure why your results are not showing up. As for merge file, that only makes it so all of your results get gathered together into one very big file of all the charachteristics for the entire job. Unless you needed it for something specific that made you go looking for it, then you probably won't need it. For excel reporting you certainly wouldn't. I wonder, if your using piWeb or not? I have not tried using Excel reports with a program that uses piWeb yet. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112796 Share on other sites More sharing options...
[Ow...] Posted November 7, 2018 Share Posted November 7, 2018 Maybe not the solution but, I do a lot of different stuff with excel and for reasons unknown, occasionally Calypso will open the excel report exactly like you said (blank) and I have to restart the computer to fix it. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112798 Share on other sites More sharing options...
[Si...] Posted November 7, 2018 Author Share Posted November 7, 2018 Please sign in to view this quote. Thanks Mark, this worked. And thanks for the presentation. Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112800 Share on other sites More sharing options...
[Cl...] Posted November 7, 2018 Share Posted November 7, 2018 cgilbert@autocam-medical.com Silvio, I have a video on how to modify the spreadsheet. E-mail me and I'll reply with it attached. I tried to attach the video to my initial response, but the forum wouldn't allow it for some reason? Maybe too big? Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112802 Share on other sites More sharing options...
[Ro...] Posted November 8, 2018 Share Posted November 8, 2018 You got PCM? You like doing things the difficult way?excel report1.JPG Link to comment https://qualityforum.zeiss.com/topic/19980-export-data-to-excel-how/#findComment-112804 Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in