I have a table which looks like the one in the attachment

This is done in excel but i will be automating it in a linux EC2 AWS server instance
I can get the ‘Today NAV’ value from an API call in the linux AWS ec2 server & update all other values using formulas.
How do i create this kind of table and output to a pdf file using CLI and bash scripting only?
PS : Its a pdf because i ll be using it to send an email daily to my gmail id so i can view the statement on my cell phone.
Thank You for the help.

Attached Thumbnails

 

You haven't tried to create a PDF file from the CLI? Regarding BASH scripting, how well do you know it?

As you know, it is helpful to other members to understand what expertise you have with these actions so they can best offer you suggestions.

There are a variety of commands or tools to convert text or standard output to a PDF file, text2pdf, and convert are two options.

My most common statement about BASH scripting is that whatever you can write in the command line, you can put into a BASH script, where the command line is the equivalent of live scripting.

Please take the time to look up and choose a PDF generation tool or command, verify you have it, or can install it on your system. If you find one and have trouble installing it on your system, then post the specification of your distribution and we'll help first with that.

Next, people can help with BASH scripting, and as I said earlier, it would be helpful to know if you already know how to write and use a script, of any language, BASH or other.

And none of that matters to the OP, since they specifically asked for Linux CLI tools...and they asked SEVEN YEARS AGO.

Hey, laptopnick, as this is your first post to LQ, I'll just say

Welcome to LQ!

You didn't realise that responding to "dead" and ancient posts is sort-of frowned upon.

No matter, you tried to help, and this is appreciated by some of us grumpy old farts.

Please don't give up on LQ, we are all here to help each other, really.

Tredegar, you're responding to a spammer.

When TB0ne posted, the post was literally the ten words quoted in post #4 - which is not relevant nor timely, as per the warning laptopnick ignored when they posted:
Unsurprisingly, they returned four days later, and edited their post to include the version you responded to, along with the link to a blatant scam website.

Even if it was a genuine site (it isn't), a paid subscription service is still not an answer to how to convert a spreadsheet to PDF using the command line.

1 members found this post helpful.

Exactly why I always quote replies, so there's never "I didn't say that!". Thanks

Why don't I update this thread with a 2024 reply.

Was just googling, and oh

https://github.com/AxlLind/mdtable-cli

https://github.com/haltcase/tablemark-cli

You then use Pandoc to convert the Markdown file to PDF.

1 members found this post helpful.