Minimum Origin Version Required: Origin 9.1 SR0
Change data plot to use another sheet.
BOOL ChangeSheet(LPCSTR pcszWksName)
BOOL ChangeSheet(Worksheet& wks)
TRUE for success; FALSE otherwise.
EX1
void DataPlot_ChangeSheet_ex1() { // Create a new workbook. WorksheetPage wpg; if( wpg.Create("origin") ) { // Put some random data into the first worksheet. Worksheet wks = wpg.Layers(); wks.Columns(0).SetFormula("i"); wks.Columns(0).ExecuteFormula(0, -1, FALSE, 0, 0); wks.Columns(1).SetFormula("uniform(32,0.1)"); wks.Columns(1).ExecuteFormula(0, -1, FALSE, 1, 1); // Plot the first sheet. wpg.LT_execute("plotxy iy:=(2)"); // Add a 2nd worksheet with some random data. int i = wpg.AddLayer(); wks = wpg.Layers(i); wks.Columns(0).SetFormula("i*1.2"); wks.Columns(0).ExecuteFormula(0, -1, FALSE, 0, 0); wks.Columns(1).SetFormula("uniform(32,0.1)"); wks.Columns(1).ExecuteFormula(0, -1, FALSE, 1, 1); } // Now we have a workbook with two worksheets and a graph // containing a dataplot data from Sheet1. GraphLayer gl = Project.ActiveLayer(); if( gl ) { DataPlot dp = gl.DataPlots(0); if( dp ) { // Get 2nd worksheet and change data plot to use it. Worksheet wks2 = wpg.Layers(1); dp.ChangeSheet(wks2); } } }
origin.h