Advertisement
ZarTek-CREOLE

Untitled

Mar 4th, 2023
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function ExtractRange(worksheet: Worksheet, starColumn: number, iRow: number): Range {
  2.   let currentCol = startCol + 1;
  3.   while (worksheet.getColumn(currentCol).length > 0 && worksheet.getCell(iRow, currentCol).value !== null) {
  4.     currentCol++;
  5.   }
  6.   return worksheet.getCell(iRow, currentCol - 1).getRight(1);
  7. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement