Hi citras,
try the attachment for some inspiration.
For your second question: did you ever read the context help for the WriteSpreadsheetFile function? For all their inputs?
Best regards,
GerdW

using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019