Site icon Kaizen.Personal computer work.

Set text wrap.(Microsoft Excel Office Scripts)

Japanese version.

Introduces how to set up text wrap with Office scripts.

Operations

The following syntax is used (Red text indicates variable parts)

// Set text wrap
workbook.getWorksheet("sheet").getRange("cell address").getFormat().setWrapText(true);

// Release text wrap
workbook.getWorksheet("sheet").getRange("cell address").getFormat().setWrapText(false);

For those who want to learn Office script effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.

Links

Office Scripts Articles

Exit mobile version