#pragma once

#include "pch.h"

#define DEFAULT_SHEET_NO		1
#define MAX_LENGTH_SCREENTIP	247

typedef struct _ExcelPosition
{
	DWORD	dwX;
	DWORD	dwY;
} ExcelPosition;

class AFX_EXT_CLASS CExcelAutomation
{
public:
	CExcelAutomation();
	virtual ~CExcelAutomation();
	
public:
	CApplication	m_kApp;	
	CWorksheet		m_kSheet;
	CWorksheets		m_kSheets;
	CWorkbook		m_kBook;
	CWorkbooks		m_kBooks;
	CRange			m_kRange;
	

	BOOL			m_bIsAppEnable;
	BOOL			m_bIsOpen;
	BOOL			m_bIsSelect;

	CString			m_Filename;
	CString			m_szStartSel;
	CString			m_szEndSel;
	
protected:
	char			temp_buff[256];

	DWORD			m_nActiveSheetIndex;	// ÇöÀç ActiveµÈ Sheet ¹øÈ£	
	ExcelPosition	m_stLastPosition;		// ¸¶Áö¸·À¸·Î »ç¿ëÇÑ Excel À§Ä¡
	ExcelPosition	m_stLastSearch;			// ¸¶Áö¸·À¸·Î °Ë»öÇÑ Excel À§Ä¡
		
public:
	BOOL	CreateDispatch();		
	void	ShowException(LPOLESTR szMember, HRESULT hr, EXCEPINFO *pexcep, unsigned int uiArgErr);

	//-------------------------------------------------------------------------------------------------
	// Application
	void	Init( CString strPathName = _T(""), DWORD dwSheetIndex = 1 );
	BOOL	CreateExcelFile();
	BOOL	Open( const CString strFilename );
	BOOL	Save( BOOL bIsOverWrite);
	BOOL	SaveAs( BOOL bIsOverWrite, const CString strFilename );
	void	Close();

	//-------------------------------------------------------------------------------------------------
	// Workbook(s)
	BOOL	ChangeActiveWorkbook( CString strPathName );
	BOOL	ChangeActiveWorkbook( long lBook );
	long	GetBookCount();

	//-------------------------------------------------------------------------------------------------
	// WorkSheet(s)	
	BOOL	AddSheet( DWORD dwSheetIndex, CString strSheetName, BOOL bBeforeOrAfter = TRUE );	// FALSE : Before, TRUE : After
	BOOL	DeleteSheet( CString strSheetName );	
	BOOL	DeleteSheet( DWORD dwSheetIndex );
	BOOL	DeleteAllSheet();
	BOOL	SetSheetName( DWORD dwSheetIndex, CString strName );
	CString GetSheetName( DWORD dwSheetIndex );
	BOOL	ChangeSheetName( DWORD dwSheetIndex, CString strSheetName );
	BOOL	SetActiveSheet( DWORD dwSheetIndex );
	BOOL	SetActiveSheetCell( DWORD dwSheetIndex, const CString strStartSel, const CString strEndSel );
	BOOL	SetActiveSheet( CString strSheetName );
	BOOL	CopySheets( CString strPathNameSrc, CString strPathNameDest, CString strSheetNameDest, BOOL bBeforeOrAfter = TRUE );	// FALSE : Before, TRUE : After
	BOOL	CopySheets( CString strPathNameSrc,	CString strPathNameDest, long lSheetDest, BOOL bBeforeOrAfter = TRUE );				// FALSE : Before, TRUE : After
	BOOL	CopySheet( CString strPathNameSrc, CString strSheetNameSrc, CString strPathNameDest, CString strSheetNameDest, BOOL bBeforeOrAfter = TRUE );	// FALSE : Before, TRUE : After
	BOOL	CopySheet( CString strPathNameSrc, long lSheetSrc, CString strPathNameDest, long lSheetDest, BOOL bBeforeOrAfter = TRUE );	// FALSE : Before, TRUE : After

	long	GetSheetCount();
	void	SetRowHeight(const CString strStartSel, const CString strEndSel, short sHeight);
	float	GetRangeWidth(const CString strStartSel, const CString strEndSel);
	float	GetRangeHeight(const CString strStartSel, const CString strEndSel);
	void	GetCurrentRangeTopPosition(const CString strStartSel, const CString strEndSel);


	void	SetVisible( BOOL bSet = TRUE );
	
	long	GetMaxRows(int nSheetIndex);
	long	GetMaxCols(int nSheetIndex);

	BOOL	Select(int nSheetIndex, const CString strStartSel, const CString strEndSel);
	void	UnSelect();

	CString GetData(int nSheetIndex, const CString strSel);
	void	SetData(const CString strFillData);
	void	SetData(int nSheetIndex, const CString strSel, const CString strFillData);
	void	SetData(int nSheetIndex, const CString strStartSel, const CString strEndSel, const CString strFillData);
	void	SetData(int nSheetIndex, const CString strSel, const CString strFillData, int nFormat);
	void	SetData(int nSheetIndex, const CString strStartSel, const CString strEndSel, const CString strFillData, int nFormat);

	void	SetMergeColorData(int nSheetIndex, const CString strStartSel, const CString strEndSel, const CString strFillData,
							  COLORREF cBGColor = NULL, BOOL bMerge = TRUE);

	void	SetFormula(int nSheetIndex, const CString strSel, const CString strFillData);
	void	SetFormula(int nSheetIndex, const CString strStartSel, const CString strEndSel, const CString strFillData);
	
	void	SetDataFormat( int nFormat );
	void	SetAlign( int nHAlign, int nVAlign, BOOL bIsOrientation = FALSE );
	void	SetHorizontalAlign( int nHAlign );
	void	SetVerticalAlign( int nVAlign );
	void	SetAlignment( CString strCellAddrsrt, CString strCellAddr2end, short iHorizontal, short iVertical );

	void	SetFont( short nSize, const CString Fontname, BOOL bIsItalic, BOOL bIsUnderLine, BOOL bIsBold, COLORREF color = NULL );
	void	SetFont( CString strCellAddrsrt, CString strCellAddr2end, BOOL bBold, short iSize, CString strFontName, COLORREF color );
	void	SetLine( short nLineStyle, short nWeight );
	void	SetColor( int nRed, int nGreen, int nBlue );
	void	SetColor( COLORREF crColor );

	void	SetMerge();
	void	SetAutoFit();
		
	void	AutoFitColumns( CString strCellAddrsrt, CString strCellAddr2end );
	void	SetColumnWidth( CString strCellAddr, long lWidth );
	void	SetForeColor( CString strCellAddrsrt, CString strCellAddr2end, COLORREF color );
	void	SetBackColor( CString strCellAddrsrt, CString strCellAddr2end, COLORREF color );
	void	DrawBorders( CString strCellAddrsrt, CString strCellAddr2end, short iLineStyle, short iWeight );
	void	DrawBorder( CString strCellAddrsrt, CString strCellAddr2end, short iLineStyle, short iWeight, long lBordersIndex );
	void	SetHyperlink( CString strCellAddr, CString strCellLink, CString strScreenTip, CString strDisp );
	void	MoveToCell( CString strSheetName, CString strCellAddr );
	void	MoveToCell( long lSheet, CString strCellAddr );
	void	SetFormula( CString strCellAddrsrt, CString strCellAddr2end, CString strValue );
	long	GetNumRows();
	long	GetNumCols();
	BOOL	CopyRange( CString strPathNameSrc, long lSheetSrc, CString strCellAddrsrtSrc, CString strCellAddr2endSrc, CString strPathNameDest, long lSheetDest, CString strCellAddrDest );
	void	DeleteRange( CString strCellAddrsrt, CString strCellAddr2end, short iDeleteShiftDirection );
	void	AutoFilter( CString strCellAddrsrt, CString strCellAddr2end );
	void	AddComment( CString strSheetName, CString strCellAddr, CString strComment, float fWidth, float fHeight );
	void	SetConditionalFormat( CString strCellAddrsrt, CString strCellAddr2end, long lType, CString strFormula, COLORREF color );

	void	Insert( CString strCellAddrsrt, CString strCellAddr2end, short iShiftDirection, short iCopyOrigin );
	void	AutoFill( CString strCellAddrsrt1, CString strCellAddrsrt2, CString strCellAddr2end );
	void	ClearContents( CString strCellAddrsrt, CString strCellAddr2end );

	BOOL	GetEnableApp()	{ return m_bIsAppEnable; }
	BOOL	GetOpenFile()	{ return m_bIsOpen; }
	BOOL	GetSelect()		{ return m_bIsSelect; }

	CString	GetStartSel()	{ return m_szStartSel; }
	CString	GetEndSel()		{ return m_szEndSel; }

	DWORD	GetCurrentSheetIndex() { return m_nActiveSheetIndex; }
	void	SetCurrentSheetIndex( DWORD nIndex ) { m_nActiveSheetIndex = nIndex; }

	char*	GetSheetCellPosition(int nCellIndex);

	void	SetPageHeaderFooter(BOOL bIsHeader,int nAlign, int nFontSize, const CString strFont, CString strData);
	void	SetPageControl(BOOL bCenterHorizontally, BOOL bCenterVertically, int nOutDirection, int nZoom = 100);
	void	SetPageMargin(float Left=0.75, float Right=0.75, float Top=1, float Bottom=1, float Header=0.5, float Footer=0.5);

	void	FreezePanes( BOOL bIsValue );
	void	SetFreezePanes( CString strSheetName, CString strCellAddr, BOOL bFreezePanes );
	void	SetFreezePanes( long nSheetIndex, CString strCellAddr, BOOL bFreezePanes );

	void	PrintOut(int nSheetIndex, const CString strStartSel, const CString strEndSel, int nStartPage, int nEndPage, int nCopies, const CString strFileName );

	void	AddMemo(int nSheetIndex, const CString strSel, const CString strFillData);
	void	AddTextBox( int nSheetIndex, const CString strStartSel, const CString strEndSel,
						float nLeft, float nTop, float nWidth, float nHeight,
						short nSize, BOOL bIsBold, const CString strFillData );

	BOOL	ConvertAlphabet2Number( char *pbVal, DWORD &pdwNumber );		// Convert Alphabet to Number (A:1, AA:27, ...)
	int		ConvertAlphabet2Number( CString strAlpha );		// Convert Alphabet to Number (A:1, AA:27, ...)
	CString ConvertNumber2Alphabet( int nNum );
	///int		ConvertAlphabet2Number(CString s);
	
	// [2019/02/01 18:22:12 by jylee] related Picture
	void	InsertPicture( CString strPicture );	
	///void	InsertPicture( int nSheetIndex, const CString strStartSel, const CString strEndSel, CString strImagePath, const int nLeft, const int nTop, const int nWidth, const int nHeight );
	void	InsertPicture( const CString strStartSel, const CString strEndSel, CString strImagePath, const int nLeft, const int nTop, const int nWidth, const int nHeight );
	void	InsertPicture( CString strImagePath, const int nLeft, const int nTop, const int nWidth, const int nHeight );
	double	GetImageWidth( CString strImagePath );
	double	GetImageHeight( CString strImagePath );

protected:
	void	Release();

};