Wraps a worksheet name in single quotes when it contains characters that require escaping in an address.
(sheetName: string)
| 50 | |
| 51 | /** Wraps a worksheet name in single quotes when it contains characters that require escaping in an address. */ |
| 52 | function quoteSheetName(sheetName: string): string { |
| 53 | if (/^[A-Za-z0-9_]+$/.test(sheetName)) return sheetName |
| 54 | return `'${sheetName.replace(/'/g, "''")}'` |
| 55 | } |
| 56 | |
| 57 | export const MicrosoftExcelBlock: BlockConfig<MicrosoftExcelResponse> = { |
| 58 | type: 'microsoft_excel', |
no test coverage detected