All Forums  Origin Forum for Programming  Forum for Origin C  plot scaling factor and excel exporting

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by cab0008[/i] [br]Does anyone know what the origin C code is to change the scaling factor on a graph? I'm pretty new to programming, so I'm not that great, but I was hoping I could get just a couple functions that aren't as well known. The specific plot I want to change, as listed under the Plot details dialog box, is: [GRAPHENEDATA]Sheet1!"Hex Intensities"(S),"value(2N+M)/2"(X),"vale-M"(Y)[1*.41*] for the graph "Graphene_sheet". So the best thing I could find in searching was something like this: Graphene_sheet!layer1.factor = 42. Although that's way off I'm sure. It may even be the wrong factor, and it only addresses the whole graph - not the specific plot. Also, I wanted to know if you can export all of the worksheets as excel files. I know that it is possible to have the graphs exported as bmp images, so I thought it may be somewhat similar to this code. I made some small modifications to that code shown here: foreach( PageBase pgb in Project.Pages ) { if( EXIST_WKS == pgb.GetType() ) { WorksheetPage wp(pgb); string strFormat = "XLS"; string fldr = "P:\Lab\Fluorescence data\Results\\" + Project.GetName(); CreateDirectory(fldr, NULL); string strImagePath = fldr + '\\' + Project.GetName() + '-' + wp.GetName() + ".XLS"; printf("File: %s\n", strImagePath); // Call function to export page with desired settings BOOL bRet = export_page_to_xls(strImagePath, strFormat, wp); // Report on error if( !bRet ) printf("Failed to export xls page: %s\n", pgb.GetName()); } } I'm still missing something important because the export_page_to_xls() function is nonexistent. So my main question is if there exists anything that will perform that type of function. Thank you for any help. Origin Ver. and Service Release (Select Help-->About Origin): 8.0.63.988 SR6 Operating System: Windows XP [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.