//---------------------------------------------------------------------------

#ifndef ExcelH
#define ExcelH
//---------------------------------------------------------------------------

#include <vcl.h>


enum { exA=1,exB,  exC,  exD,  exE,  exF,  exG,  exH,  exI,  exJ,  exK,  exL,  exM,  exN,  exO,  exP,  exQ,  exR,  exS,  exT,  exU,  exV,  exW,  exX,  exY,  exZ,
       exAA, exAB, exAC, exAD, exAE, exAF, exAG, exAH, exAI, exAJ, exAK, exAL, exAM, exAN, exAO, exAP, exAQ, exAR, exAS, exAT, exAU, exAV, exAW, exAX, exAY, exAZ};


class CExcel
{
public:
    __fastcall CExcel();
    __fastcall ~CExcel();

public:
    Variant m_xlApp, m_xlBooks, m_xlBook, m_xlSheets, m_xlSheet, m_VCell, m_CellImage, m_Range;

	bool m_bOpen;


	AnsiString m_OpenName;


public:
    bool __fastcall Open(AnsiString fName, bool bVisible);
    void __fastcall Close();
    void __fastcall Save(AnsiString fName);

    //---------------------------------------------------------------------- sheet °ü·Ã ÇÔ¼öµé
    void __fastcall OpenSheet(int SheetNo);
    void __fastcall OpenSheet(AnsiString SheetName);
    void __fastcall OpenActiveSheet();

    int __fastcall GetSheetNum();                     // ÃÑ Sheet °¹¼ö¸¦ ¾ò´Â´Ù.
    AnsiString __fastcall GetSheetName(int SheetNo);  // Sheet À̸§ ¾ò±â
    void __fastcall SetSheetName(int SheetNo, AnsiString SheetName);

    //---------------------------------------------------------------------- ¼¿ °ü·Ã ÇÔ¼öµé
    void __fastcall WriteToCell(int RowNo, int ColNo, AnsiString Data);
    AnsiString __fastcall ReadFromCell(int RowNo, int ColNo);

    void __fastcall SetCellSizeWidth(int RowNo, int ColNo, int Size);
    void __fastcall SetCellSizeHeight(int RowNo, int ColNo, int Size);
    int __fastcall GetLastRowNo(int ColNo, int AllowBlank);   // Çã¶ôµÇ´Â ºó °ø°£

    void __fastcall SetImage(int RowNo, int ColNo, AnsiString ImgPath);  // ƯÁ¤ ¼¿¿¡ À̹ÌÁö ³Ö±â
    void __fastcall JoinCell(int Row1, int Col1, int Row2, int Col2);    // ¼¿ ÇÕÄ¡±â

};


#endif