ExcelChart UDF

[jcpetu]

Hi Water, a minor issue:

_XLChart_Axis_Test.au3"(15,16) : warning: $iXLC_Debug possibly not declared/created yet

Regarding my question of the possibility to show a graph in a Window it is not the case of example 5 in _XLChart_ChartCreate.au3, I meant to show a graph within a Window as a picture taking advantage of the Excel chart objects, eg:

[water]

Thanks for this bug report.

Simply remove this line.

You could try to use  GUICtrlCreatePic and display a picture created by _XLChart_ChartExport.

[jcpetu]

OK, and is it possible to hide Excel Window while creating the chart?

[water]

When you run AutoIt 3.3.12.0 and use the Excel UDF to start Excel or connect to an already running instance then

_Excel_Open(False)

is all you need.

[jcpetu]

Thanks a lot Water, I'll give it a try.

Have a good week end.

[water]

Thanks, for you too!

[water]

Hi Water, a minor issue:

_XLChart_Axis_Test.au3"(15,16) : warning: $iXLC_Debug possibly not declared/created yet

That's a test script which shouldn't be part of the ZIP file. Simply ignore this test script. Will be removed.

[litlelee9]

Just starting using this UDF to create a column graph. The chart is created successfully but the horizontal axis defaults to automatic. I would like to change this upon creation to Text as opposed to automatic. The _XLChart_Create function does not allow for this and I could not find a way to do this in any of the other functions either...although I could have missed it. Looking for some assistance - from what I have researched I think I need to set the Axes.CategoryType property (RA: https://msdn.microsoft.com/en-us/library/office/ff839414.aspx?f=255&MSPPError=-2147217396). To test, I have duplicated the_XLChart_Create function and simply placed what I think the property command would be but have been unsuccessful thus far. Any ideas? Here is the command that i used (used value which should set it to xlCategoryScale): 

$oChart.Axes.CategoryType = 3

[water]

I think it should be:

$oChart.Axes($xlCategory).CategoryType = 3

 

[litlelee9]

THANKS - that did it!!

[water]

[SkysLastChance]

Does this UDF still work with the new excel functions? 

[water]

The latest version of the UDF works with the newest version of the Excel UDF.
To be more accurate: The ExcelChart UDF does not use any function of the Excel UDF (it directly accesses Excel). I only had to add two workarounds to cope with the latest AutoIt COM error handling problem.

Edited August 1, 2017 by water

[nicdev007]

Hi water, I've been using your Excel UDF for a few weeks now to write a GUI front-end for a shared Excel file on the network, accessed by multiple users daily. I just wanted to send out a thanks to you and anyone else involved in creating this UDF !  It works like a charm :-)

 

Cheers

Nicdev

[water]

Thanks for the feedback. Glad you like the UDF 😃

[SlavaS]

All perfectly!
Where can I download previous versions for older versions of autoit?

[water]

In the download section you only find the latest version. I can upload the needed version(s) here. Which version do you need (see file History.txt). 

[SlavaS]

for version autoit 3.3.8.1

[water]

I checked the history and see no reason why the latest version of the UDF shouldn't run with AutoIt 3.3.8.1.
Do you get any errors when you use the latest version of the UDF with Autoit 3.3.8.1?

[SlavaS]

C:\Program Files (x86)\AutoIt3_v3.3.8.1\Include\Excel.au3 (31) : ==> Can not redeclare a constant.:
Global Const $xlThin = 2
Global Const ^ ERROR

duplicates constants with excel.au3