-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Closed
Description
When we create a workbook with multiple excelsheets, only 1 tab is showing and all other is hidden. There is a text at bottm showing number of sheets ie 'Sheet 1 of 20'. I am creating sheets dynamically
`var workbook = new Excel.Workbook();
workbook.views = [
{
x: 0, y: 0, width: 1000, height: 2000,
firstSheet: 0, activeTab: 0, visibility: 'visible'
}
];
var date_created=moment(totalCryptofix.date_created).format('MM.DD.YYYY');
_.forEach(totalCryptofix.prices,function(data){
var worksheet = workbook.addWorksheet(_.toLower(data.currency));
worksheet.state = 'show';
worksheet.columns = [
{ header: 'Currency', key: 'currency', width: 40,style: { alignment: { horizontal: 'left' }}},
{ header: 'Price', key: 'price', width: 40,style: { alignment: { horizontal: 'left' }}},
{ header: 'Date', key: 'date', width: 40,style: { alignment: { horizontal: 'left' }}}
];
var date=moment(totalCryptofix.date_created).format('YYYY-MM-DD');
_.forEach(data.prices,function(price){
worksheet.addRow({currency: price.currency, price: price.price, date: date});
});
});`
Metadata
Metadata
Assignees
Labels
No labels