Jump to content
Sign in to follow this  
GAM

Excel Graphmacro in Autoit

Recommended Posts

GAM

Hi All,

I'm trying to automate the excel graphs via AutoIt scripts. The task is to create a line graph between two columns of the excel sheet. Can some let me know "how to use this use in the AUTOIT script"?. Or can some one direct me to a link where these kinda examples are stored? Please let me know if any one needs more info from me?

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Range("A:A,B:B").Select

Range("B1").Activate

Charts.Add

ActiveChart.ChartType = xlLineMarkers

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range( _

"A1:B11616"), PlotBy:=xlColumns

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Private Bytes"

With ActiveChart

.HasTitle = True

.ChartTitle.Characters.Text = _

"\\ARJUN2K322\Process(FrameworkService)\Private Bytes"

.Axes(xlCategory, xlPrimary).HasTitle = False

.Axes(xlValue, xlPrimary).HasTitle = False

End With

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


Neil

Share this post


Link to post
Share on other sites
GAM

Hi All,

I'm trying to automate the excel graphs via AutoIt scripts. The task is to create a line graph between two columns of the excel sheet. Can some let me know "how to use this use in the AUTOIT script"?. Or can some one direct me to a link where these kinda examples are stored? Please let me know if any one needs more info from me?

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Range("A:A,B:B").Select

Range("B1").Activate

Charts.Add

ActiveChart.ChartType = xlLineMarkers

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range( _

"A1:B11616"), PlotBy:=xlColumns

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Private Bytes"

With ActiveChart

.HasTitle = True

.ChartTitle.Characters.Text = _

"\\ARJUN2K322\Process(FrameworkService)\Private Bytes"

.Axes(xlCategory, xlPrimary).HasTitle = False

.Axes(xlValue, xlPrimary).HasTitle = False

End With

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; THE EXCEL MACRO SCRIPT ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Can someone help me in coding the below code in AutoIT script?

;;;;;;;;;;;;; CODE IN EXCEL MACRO ::::::::::::::::::

ActiveChart.SetSourceData Source:=Sheets("EngineServer_000002").Range("A1:B11616"), PlotBy:=xlColumns

;;;;;;;;;;;;; CODE IN EXCEL MACRO ::::::::::::::::::


Neil

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.