We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vsql Output in .xlsx — Vertica Forum

Vsql Output in .xlsx

Hi,

 

Can any one help me what is the sentx to get data in .xlsx format thru vql.

 

thanks! 

Comments

  •  Why don`t you create an ODBC connection to your Vertica database and then connect form Excel to your db ! 

  • I need to create a cron job (In Linux) and send that output to users.

     

     

  • Here is some idea that might work for you.

    - export the content of the data into csv format, any separetor would work.

    - here i use | , the trick is the "sep=|"  (it tell what is your delimiter)make sure you have this as the first line of the file, so when they open it in excel all should be aligned. 

    vsql -U dbadmin -w password -F $'|' -At -c "SELECT * FROM table_name"  > '/tmp/bla.csv'
    sed -i '1s/^/sep=|\n/' /tmp/bla.csv

    The sed command will add the delimiter as the first line in the file.

     

     

     This should do the trick :).

     

  • Wow Superb!..

  •  Happy to hear this helped :)

    You might wanna cleanup the last row of the files since is going to show the number of rows.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file