How to Control Sheet Tab Bar with Node.js via C++
Contents
[
Hide
]
Possible Usage Scenarios
When you need to adjust the display of Excel sheet bar, you need to know how to control the sheet tab bar, such as hiding or showing the sheet tab bar, changing the sheet tab bar width, specifying the first visible tab, and so on. Aspose.Cells for Node.js via C++ supports these features. Aspose.Cells provides the following properties and methods to help you achieve your goals.
- WorkbookSettings.getShowTabs()
- WorkbookSettings.getSheetTabBarWidth()
- WorkbookSettings.getFirstVisibleTab()
How to Control Sheet Tab Bar using Aspose.Cells for Node.js via C++
This example shows how to:
- Create a workbook.
- Add data to cells in the first worksheet.
- Display the sheet tab and set the width of the tab bar.
const AsposeCells = require("aspose.cells.node");
const path = require("path");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sample.xlsx");
// Loads the workbook which contains hidden external links
const workbook = new AsposeCells.Workbook();
// Obtaining the reference of the newly added worksheet
const ws = workbook.getWorksheets().get(0);
const cells = ws.getCells();
// Setting the value to the cells
let cell = cells.get("A1");
cell.putValue("Fruit");
cell = cells.get("B1");
cell.putValue("Count");
cell = cells.get("C1");
cell.putValue("Price");
cell = cells.get("A2");
cell.putValue("Apple");
cell = cells.get("A3");
cell.putValue("Mango");
cell = cells.get("A4");
cell.putValue("Blackberry");
cell = cells.get("A5");
cell.putValue("Cherry");
// Display the sheet tab and set the width of the tab bar
workbook.getSettings().setShowTabs(true);
workbook.getSettings().setSheetTabBarWidth(150);
workbook.save("out.xlsx");
Result file preview: