View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joannes Vermorel Joannes Vermorel is offline
external usenet poster
 
Posts: 9
Default How to parse UDF arguments? (separators are localized)

We have designed an add-in for Excel 2003 in C# that need to parse the
arguments of an Excel UDF function (the content of the cell being
retrieved as text).

So far, we were just using an ad-hoc parser, but it fails within
localized version of Excel that do not use the comma as argument
separator.

What it the "safe" way to parse Excel function arguments? Is there any
way to know what is the separator character that should be used?

Thanks in advance,
Joannès