290 lines
8.0 KiB
C++
290 lines
8.0 KiB
C++
/*
|
|
* (c) Copyright Ascensio System SIA 2010-2023
|
|
*
|
|
* This program is a free software product. You can redistribute it and/or
|
|
* modify it under the terms of the GNU Affero General Public License (AGPL)
|
|
* version 3 as published by the Free Software Foundation. In accordance with
|
|
* Section 7(a) of the GNU AGPL its Section 15 shall be amended to the effect
|
|
* that Ascensio System SIA expressly excludes the warranty of non-infringement
|
|
* of any third-party rights.
|
|
*
|
|
* This program is distributed WITHOUT ANY WARRANTY; without even the implied
|
|
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. For
|
|
* details, see the GNU AGPL at: http://www.gnu.org/licenses/agpl-3.0.html
|
|
*
|
|
* You can contact Ascensio System SIA at 20A-6 Ernesta Birznieka-Upish
|
|
* street, Riga, Latvia, EU, LV-1050.
|
|
*
|
|
* The interactive user interfaces in modified source and object code versions
|
|
* of the Program must display Appropriate Legal Notices, as required under
|
|
* Section 5 of the GNU AGPL version 3.
|
|
*
|
|
* Pursuant to Section 7(b) of the License you must retain the original Product
|
|
* logo when distributing the program. Pursuant to Section 7(e) we decline to
|
|
* grant you any rights under trademark law for use of our trademarks.
|
|
*
|
|
* All the Product's GUI elements, including illustrations and icon sets, as
|
|
* well as technical writing content are licensed under the terms of the
|
|
* Creative Commons Attribution-ShareAlike 4.0 International. See the License
|
|
* terms at http://creativecommons.org/licenses/by-sa/4.0/legalcode
|
|
*
|
|
*/
|
|
#pragma once
|
|
|
|
#include "XlsxFlat.h"
|
|
|
|
#include "Workbook/Workbook.h"
|
|
#include "SharedStrings/SharedStrings.h"
|
|
#include "Styles/Styles.h"
|
|
#include "Worksheets/Worksheet.h"
|
|
#include "Workbook/DefinedNames.h"
|
|
|
|
#include "Styles/Borders.h"
|
|
#include "Styles/CellStyles.h"
|
|
#include "Styles/Xfs.h"
|
|
#include "Styles/Colors.h"
|
|
#include "Styles/dxf.h"
|
|
#include "Styles/Fills.h"
|
|
#include "Styles/Fonts.h"
|
|
#include "Styles/NumFmts.h"
|
|
#include "Styles/TableStyles.h"
|
|
|
|
#include "ComplexTypes_Spreadsheet.h"
|
|
|
|
namespace OOX
|
|
{
|
|
namespace Spreadsheet
|
|
{
|
|
CXlsxFlat::CXlsxFlat() : File(dynamic_cast<Document*>(this))
|
|
{
|
|
m_nLastReadRow = 0;
|
|
m_nLastReadCol = -1;
|
|
|
|
m_maxDigitSize = std::make_pair(0, 0);
|
|
}
|
|
CXlsxFlat::CXlsxFlat(const CPath& oFilePath) : File(this)
|
|
{
|
|
m_nLastReadRow = 0;
|
|
m_nLastReadCol = -1;
|
|
|
|
m_maxDigitSize = std::make_pair(0, 0);
|
|
|
|
read( oFilePath );
|
|
}
|
|
CXlsxFlat::~CXlsxFlat()
|
|
{
|
|
m_pWorkbook.reset();
|
|
m_pStyles.reset();
|
|
m_pSharedStrings.reset();
|
|
|
|
for (size_t i = 0; i < m_arWorksheets.size(); ++i)
|
|
{
|
|
if (m_arWorksheets[i])
|
|
{
|
|
delete m_arWorksheets[i];
|
|
m_arWorksheets[i] = NULL;
|
|
}
|
|
}
|
|
m_arWorksheets.clear();
|
|
}
|
|
|
|
void CXlsxFlat::read(const CPath& oFilePath)
|
|
{
|
|
XmlUtils::CXmlLiteReader oReader;
|
|
|
|
if ( !oReader.FromFile( oFilePath.GetPath() ) )
|
|
return;
|
|
|
|
if ( !oReader.ReadNextNode() )
|
|
return;
|
|
|
|
fromXML(oReader);
|
|
}
|
|
void CXlsxFlat::write(const CPath& oFilePath, const CPath& oDirectory, CContentTypes& oContent) const
|
|
{
|
|
std::wstring sXml = toXML();
|
|
|
|
NSFile::CFileBinary file;
|
|
file.CreateFileW(oFilePath.GetPath());
|
|
file.WriteStringUTF8(sXml);
|
|
file.CloseFile();
|
|
}
|
|
const OOX::FileType CXlsxFlat::type() const
|
|
{
|
|
return OOX::Spreadsheet::FileTypes::SpreadsheetFlat;
|
|
}
|
|
const CPath CXlsxFlat::DefaultDirectory() const
|
|
{
|
|
return type().DefaultDirectory();
|
|
}
|
|
const CPath CXlsxFlat::DefaultFileName() const
|
|
{
|
|
return type().DefaultFileName();
|
|
}
|
|
void CXlsxFlat::fromXML(XmlUtils::CXmlNode& oNode)
|
|
{
|
|
}
|
|
std::wstring CXlsxFlat::toXML() const
|
|
{
|
|
std::wstring sXml = L"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>";
|
|
|
|
return sXml;
|
|
}
|
|
void CXlsxFlat::toXML(NSStringUtils::CStringBuilder& writer) const
|
|
{
|
|
}
|
|
EElementType CXlsxFlat::getType() const
|
|
{
|
|
return et_x_SpreadsheetFlat;
|
|
}
|
|
void CXlsxFlat::fromXML(XmlUtils::CXmlLiteReader& oReader)
|
|
{
|
|
if ( oReader.IsEmptyNode() )
|
|
return;
|
|
|
|
if (false == m_pWorkbook.IsInit())
|
|
{
|
|
m_pWorkbook = new CWorkbook(dynamic_cast<OOX::Document*>(this));
|
|
}
|
|
if (false == m_pSharedStrings.IsInit())
|
|
{
|
|
m_pSharedStrings = new CSharedStrings(dynamic_cast<OOX::Document*>(this));
|
|
}
|
|
int nStylesDepth = oReader.GetDepth();
|
|
while ( oReader.ReadNextSiblingNode( nStylesDepth ) )
|
|
{
|
|
std::wstring sName = XmlUtils::GetNameNoNS(oReader.GetName());
|
|
|
|
if ( L"ExcelWorkbook" == sName )
|
|
{
|
|
m_pWorkbook->fromXML(oReader);
|
|
}
|
|
else if (L"OfficeDocumentSettings" == sName)
|
|
{
|
|
ReadSettingAttributes(oReader);
|
|
}
|
|
else if ( L"Worksheet" == sName )
|
|
{
|
|
CWorksheet *pWorksheet = new CWorksheet(dynamic_cast<OOX::Document*>(this));
|
|
m_arWorksheets.push_back(pWorksheet);
|
|
|
|
pWorksheet->fromXML(oReader);
|
|
}
|
|
else if ( L"Styles" == sName )
|
|
{
|
|
m_pStyles = new CStyles(dynamic_cast<OOX::Document*>(this));
|
|
m_pStyles->fromXML(oReader);
|
|
}
|
|
else if ( L"Names" == sName )
|
|
{
|
|
m_pWorkbook->m_oDefinedNames = new CDefinedNames(dynamic_cast<OOX::Document*>(this));
|
|
m_pWorkbook->m_oDefinedNames->fromXML(oReader);
|
|
}
|
|
}
|
|
}
|
|
std::pair<double, double> CXlsxFlat::getMaxDigitSize()
|
|
{
|
|
if (m_maxDigitSize.first <= 0.1)
|
|
{
|
|
COfficeFontPicker* pFontPicker = new COfficeFontPicker();
|
|
pFontPicker->Init(m_strFontDirectory);
|
|
NSFonts::IFontManager* pFontManager = pFontPicker->get_FontManager();
|
|
|
|
std::wstring fontName = L"Arial";
|
|
double fontSize = 10;
|
|
int fontStyle = 0;
|
|
//-----------------------------------------------------------
|
|
if ((m_pStyles.IsInit()) && (m_pStyles->m_oFonts.IsInit()) && (false == m_pStyles->m_oFonts->m_arrItems.empty()))
|
|
{
|
|
fontSize = m_pStyles->m_oFonts->m_arrItems[0]->m_oSz->m_oVal->GetValue();
|
|
fontName = *m_pStyles->m_oFonts->m_arrItems[0]->m_oRFont->m_sVal;
|
|
}
|
|
//-----------------------------------------------------------
|
|
int hr = FALSE;
|
|
|
|
double dpi = 96;
|
|
if (FALSE == (hr = pFontManager->LoadFontByName(fontName, fontSize, fontStyle, dpi, dpi)))
|
|
{
|
|
if (FALSE == (hr = pFontManager->LoadFontByName(L"Arial", fontSize, fontStyle, dpi, dpi)))
|
|
{
|
|
delete pFontPicker;
|
|
m_maxDigitSize = std::pair<double, double>(7, 8);
|
|
return m_maxDigitSize;
|
|
}
|
|
}
|
|
|
|
double maxWidth = 0;
|
|
double maxHeight = 0;
|
|
|
|
double minWidth = 0xffffffff;
|
|
double minHeight = 0xfffffff;
|
|
|
|
// for (int i = 0; i <= 9; ++i)
|
|
//{
|
|
//if (FALSE == (hr = pFontManager->LoadString2( std::to_wstring(i), 0, 0)))
|
|
// return std::pair<float, float>(7,8);
|
|
//TBBox box;
|
|
//try
|
|
//{
|
|
// box = pFontManager->MeasureString();
|
|
//}
|
|
//}
|
|
if (FALSE == (hr = pFontManager->LoadString2(L"0123456789", 0, 0)))//
|
|
{
|
|
m_maxDigitSize = std::pair<double, double>(7., 8.);
|
|
return m_maxDigitSize;
|
|
}
|
|
|
|
TBBox box;
|
|
try
|
|
{
|
|
box = pFontManager->MeasureString();
|
|
}
|
|
catch (...)
|
|
{
|
|
m_maxDigitSize = std::pair<double, double>(7., 8.);
|
|
return m_maxDigitSize;
|
|
}
|
|
|
|
if (box.fMaxX < -0xffff + 1 || box.fMaxY < -0xffff + 1 ||
|
|
box.fMinX > 0xffff - 1 || box.fMinY > 0xffff - 1)
|
|
{
|
|
m_maxDigitSize = std::pair<double, double>(7., 8.);
|
|
return m_maxDigitSize;
|
|
}
|
|
|
|
if (box.fMaxX - box.fMinX > maxWidth) maxWidth = box.fMaxX - box.fMinX;
|
|
if (box.fMaxY - box.fMinY > maxHeight) maxHeight = box.fMaxY - box.fMinY;
|
|
|
|
if (box.fMaxX - box.fMinX < minWidth) minWidth = box.fMaxX - box.fMinX;
|
|
if (box.fMaxY - box.fMinY < minHeight) minHeight = box.fMaxY - box.fMinY;
|
|
|
|
double width = (minWidth + 2 * maxWidth) / 10. / 3.;
|
|
|
|
if (width > 0.01 && maxHeight > 0.01)
|
|
m_maxDigitSize = std::pair<double, double>(width, maxHeight);
|
|
else
|
|
m_maxDigitSize = std::pair<double, double>(7., 8.);
|
|
|
|
delete pFontPicker;
|
|
}
|
|
return m_maxDigitSize;
|
|
}
|
|
|
|
void CXlsxFlat::ReadSettingAttributes(XmlUtils::CXmlLiteReader& oReader)
|
|
{
|
|
nullable_bool bReadOnly;
|
|
WritingElement_ReadAttributes_Start(oReader)
|
|
WritingElement_ReadAttributes_Read_if(oReader, L"ReadOnlyRecommended", bReadOnly)
|
|
WritingElement_ReadAttributes_End(oReader)
|
|
|
|
if (bReadOnly.IsInit())
|
|
{
|
|
m_pWorkbook->m_oFileSharing.Init();
|
|
m_pWorkbook->m_oFileSharing->m_oReadOnlyRecommended = true;
|
|
}
|
|
}
|
|
}
|
|
|
|
}
|