Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've asked this before...(x-axis day of week)
A repost from a few months ago...
I am exporting data into Excel via Automation using C++. When I invoke the function below for a chart... Axis axisX = chart.Axes(COleVariant((short)xlCategory), xlPrimary); TickLabels tickLabels = axisX.GetTickLabels(); // set x-axis label to show 'Sun' 'Mon' 'Tue' etc. tickLabels.SetNumberFormat("ddd"); It works ok for English and some other countries, but does not work in German or French. Excel complains with an error dialog. It works ok in German if the string becomes "TTT", in French it is ok if it is "jjj". However, it seems to be quite a pain to figure out what all of these strings should be for each country. Is there a better way to do this than creating my own table and looking up the country codes? Where do these actual strings live ? Anyway to retrieve them programmatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
This has been asked, but not answered... | Excel Discussion (Misc queries) | |||
I bet this has been asked before | Excel Discussion (Misc queries) | |||
Someone must have asked this before but I can't find it! | Excel Discussion (Misc queries) | |||
day of week and time on X axis of a graph | Charts and Charting in Excel | |||
grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel |