Java Export to Excel - Format Column - Number and String

Hi Guys,

I am trying to export an excel file using ActiveXObject…

In this file I want to use the format X days.

If I format the cell after the exportation and use the type #" days" it will work.

I tried use “#”" days"“” format generated by the Macro and put on the code, but it didn’t work.

I’m trying several types, such as #’ days’ , "#+" days" …

Can you help me ?

Thank you,
Eric

Hi ericyuri, welcome to the forums,

Sorry but I’m a bit confused, you posted in the javascript forum, the thread title says Java, but you mention ActiveX
It should help if you post more about the macro you currently tying to use.

Hi Mittineague,

Sorry about that, but actually the code is a mix between ActiveX and JavaScript. I wrote here because I read that someone posted in this forum similiar question. :slight_smile:

Thank you,
Eric