0

How can I multiple the selected range in Excel using Office Script by 1?

I'm trying to use the Excel trick of converting dates and numbers that aren't dates and numbers into being so by multiplying by 1.

I can easily do this in VBA but I was looking for Office Script solution as this is then available for all files regardless.

I can't find a method that will allow me to iterate over the selected cells.

Thanks

Improve this question
1
  • Are you trying to convert a date stored in Excel to a JavaScript Date object? If so, this sample might help: JavaScript Date samples. Commented Dec 13, 2024 at 19:22
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
1
Excel Office Script to FillDown
2
Excel Script keeps giving error "Range merge: You cannot perform the requested operation."
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.