Sign in to follow this  
Followers 0
GAM

Excel Graphmacro in Autoit

2 posts in this topic

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



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  
Followers 0