The problem I face is that when Users download data from my Caspio results table they get an unformated Excel file. It would be great to somehow apply a template to adjust column/row widths, fonts, add a logo, etc., so that when the user opens up the Excel file, all looks consistent and professional. Obviously there's no standard feature in Caspio to do this, but I'm wondering whether such a setup could even be possible. I'd even be happy to write an Excel macro to do the formatting (and call the data) if that could form part of the solution. What makes it tougher is that the whole process would need to happen on the fly.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Farnsbarnes
The problem I face is that when Users download data from my Caspio results table they get an unformated Excel file. It would be great to somehow apply a template to adjust column/row widths, fonts, add a logo, etc., so that when the user opens up the Excel file, all looks consistent and professional. Obviously there's no standard feature in Caspio to do this, but I'm wondering whether such a setup could even be possible. I'd even be happy to write an Excel macro to do the formatting (and call the data) if that could form part of the solution. What makes it tougher is that the whole process would need to happen on the fly.
Any advice much appreciated.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.