import { type sheets_v4 } from 'googleapis';
import { type SheetsClient } from './types.js';
/** Cell value type - can be string, number, boolean, or null */
type CellValue = string | number | boolean | null;
/**
 * Converts A1 notation to row/column indices (0-based)
 * Example: "A1" -> {row: 0, col: 0}, "B2" -> {row: 1, col: 1}
 */
export declare function a1ToRowCol(a1: string): {
    row: number;
    col: number;
};
/**
 * Converts row/column indices (0-based) to A1 notation
 * Example: {row: 0, col: 0} -> "A1", {row: 1, col: 1} -> "B2"
 */
export declare function rowColToA1(row: number, col: number): string;
/**
 * Validates and normalizes a range string
 * Examples: "A1" -> "Sheet1!A1", "A1:B2" -> "Sheet1!A1:B2"
 */
export declare function normalizeRange(range: string, sheetName?: string): string;
/**
 * Reads values from a spreadsheet range
 */
export declare function readRange(sheets: SheetsClient, spreadsheetId: string, range: string): Promise<sheets_v4.Schema$ValueRange>;
/**
 * Writes values to a spreadsheet range
 */
export declare function writeRange(sheets: SheetsClient, spreadsheetId: string, range: string, values: CellValue[][], valueInputOption?: 'RAW' | 'USER_ENTERED'): Promise<sheets_v4.Schema$UpdateValuesResponse>;
/**
 * Appends values to the end of a sheet
 */
export declare function appendValues(sheets: SheetsClient, spreadsheetId: string, range: string, values: CellValue[][], valueInputOption?: 'RAW' | 'USER_ENTERED'): Promise<sheets_v4.Schema$AppendValuesResponse>;
/**
 * Clears values from a range
 */
export declare function clearRange(sheets: SheetsClient, spreadsheetId: string, range: string): Promise<sheets_v4.Schema$ClearValuesResponse>;
/**
 * Gets spreadsheet metadata including sheet information
 */
export declare function getSpreadsheetMetadata(sheets: SheetsClient, spreadsheetId: string): Promise<sheets_v4.Schema$Spreadsheet>;
/**
 * Creates a new sheet/tab in a spreadsheet
 */
export declare function addSheet(sheets: SheetsClient, spreadsheetId: string, sheetTitle: string): Promise<sheets_v4.Schema$BatchUpdateSpreadsheetResponse>;
/**
 * Formats cells in a range
 * Note: This function requires the sheetId. For simplicity, we'll get it from the spreadsheet metadata.
 */
export declare function formatCells(sheets: SheetsClient, spreadsheetId: string, range: string, format: {
    backgroundColor?: {
        red: number;
        green: number;
        blue: number;
    };
    textFormat?: {
        foregroundColor?: {
            red: number;
            green: number;
            blue: number;
        };
        fontSize?: number;
        bold?: boolean;
        italic?: boolean;
    };
    horizontalAlignment?: 'LEFT' | 'CENTER' | 'RIGHT';
    verticalAlignment?: 'TOP' | 'MIDDLE' | 'BOTTOM';
}): Promise<sheets_v4.Schema$BatchUpdateSpreadsheetResponse>;
/**
 * Deletes a sheet/tab from a spreadsheet
 */
export declare function deleteSheet(sheets: SheetsClient, spreadsheetId: string, sheetId: number): Promise<sheets_v4.Schema$BatchUpdateSpreadsheetResponse>;
export {};
//# sourceMappingURL=googleSheetsApiHelpers.d.ts.map