SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member ericyuri's Avatar
    Join Date
    Sep 2013
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,173
    Mentioned
    190 Post(s)
    Tagged
    2 Thread(s)
    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.

  3. #3
    SitePoint Member ericyuri's Avatar
    Join Date
    Sep 2013
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face

    Quote Originally Posted by Mittineague View Post
    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.

    Thank you,
    Eric


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •