Alpha DevCon 2018
Results 1 to 1 of 1

Thread: Excel updates

  1. #1
    Member
    Real Name
    John Berry
    Join Date
    Nov 2007
    Location
    Maryland, USA
    Posts
    587

    Default Excel updates

    Hi everyone,

    I'm using an Export button to export my grid to Excel. Now I need to open it and format it and I'm stuck.

    How do I open it up for editing?
    How do I open a new line at the top and add new text?
    How do I change the background colors (see the pic for an example. Blue, Accent 1, Lighter 80% but I will settle for anything at this point)
    How do I hide columns G and M?

    I see things like:

    Font.Color = Office::Color::red
    Font.Name = "Tahoma"
    Font.Size = 24
    ...

    but nothing to change the background color.

    Or is there a better solution? I guess I could create the blank spreadsheet with all columns and all the colors already setup and then loop through my recordset and put the numbers into the correct cells and hide those I don't need but that seems like more work then just Exporting the grid and THEN going back to format it. I see a lot of help on it but I'm just not getting it.

    Advice or simple example will be greatly appreciated.

    Thanks

    -John
    Attached Images Attached Images

Similar Threads

  1. how to import data excel from excel file was exported from alpha?
    By amitloh in forum Mobile & Browser Applications
    Replies: 6
    Last Post: 04-12-2017, 03:11 PM
  2. Is there a way to format the Excel file generated in the Grid Export to Excel?
    By WindForce in forum Mobile & Browser Applications
    Replies: 13
    Last Post: 01-05-2017, 07:45 PM
  3. Export to Excel funtion runs but blank with only column headers in Excel
    By clankford in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 04-12-2016, 04:05 PM
  4. Excel Export - Multiple Result Sets to One Excel file possible?
    By lauraRedway in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 10-20-2015, 08:20 PM
  5. how to import data excel from excel file was exported from alpha?
    By zatuzee in forum Mobile & Browser Applications
    Replies: 9
    Last Post: 07-21-2015, 06:00 AM

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
  •