Options
Export an array to excel range in image pro 4.5
Hi:
We are using a legacy version of image pro - 4.5.1.
We are desiring to export an array of data obtained from a line profile into an excel sheet as a range - all in one fell swoop. Our current method does this but one cell at a time. This is time consuming and resource consuming. We run out of memory very quickly. Is there a way to export an array obtained in image pro to a range in excel all at one time and without stalling due to overwhelming computer resources?
We are using a legacy version of image pro - 4.5.1.
We are desiring to export an array of data obtained from a line profile into an excel sheet as a range - all in one fell swoop. Our current method does this but one cell at a time. This is time consuming and resource consuming. We run out of memory very quickly. Is there a way to export an array obtained in image pro to a range in excel all at one time and without stalling due to overwhelming computer resources?
Tagged:
0
Best Answer
-
You can just activate macro recording and change the fields you want to see the names of the properties.
Here is my test macro where I changes Sheet names ("topic") and exported data to 2 sheets:Sub TestExcel()ret = IpDde(DDE_SET, "topic", "[Book1]Sheet2")ret = IpDde(DDE_SET, "target", "C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE")ret = IpProfSave("", S_DDE+S_DATA+S_X_AXIS)ret = IpDde(DDE_SET, "topic", "[Book1]Sheet3")ret = IpDde(DDE_SET, "target", "C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE")ret = IpProfSave("", S_DDE+S_DATA+S_X_AXIS)End Sub
Yuri0
Answers
Why don't you use Export Data function, which exports everything to Excel in one go:
Yuri
Did not think to try this. Will give it a try. One thing is that we are attempting to put the data in specific spots (columns) in a specific order. We are attempting to do this for a great number of images in series, and the data needs to placed in such a way that it can be organized for further analysis.
Yuri
Yuri
This helped us get to where we need to go.