Excel workbook with multiple worksheets?

[EvaY]

Does anyone have example source that utilizes vvOut_ssOpenWorksheet to create multiple worksheets in a workbook?

Thanks,
Eva

[robert.swanson]

Many of the Portal Admin back-end programs use that procedure. VVADM_APPS, VVADM_CATS, VVADM_USRS, etc.

[EvaY]

Great! I'll check them out. Thanks Rob!

[EvaY]

Hey Rob,

A related question...
Using the programs you mentioned as a guide, I was able to figure out how to create a spreadsheet the "new way" that you're doing it (as compared to our old way). We were creating .xls workbooks and I'm now doing the .xlsx workbooks like your admin programs do. We had customized the template file for the xls sheet to allow for custom styles. How can we do this for the .xlsx files?

Thanks!
Eva

[robert.swanson]

Hi Eva,

FYI, we have a blog post up now that discusses .xlsx styling (specific to Valence 4.2).

https://www.cnxcorp.com/2016/03/28/s...s-valence-4-2/

[EvaY]

Thanks Rob!