windows 平台下 xlnt 结合visual studio 2015 用c++操作excel的库文件

// Copyright (c) 2014-2018 Thomas Fussell // Copyright (c) 2010-2015 openpyxl // // Permission is hereby granted, free of charge, to any person obtaining a copy // of this software and associated documentation files (the "Software"), to deal // in the Software without restriction, including without limitation the rights // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell // copies of the Software, and to permit persons to whom the Software is // furnished to do so, subject to the following conditions: // // The above copyright notice and this permission notice shall be included in // all copies or substantial portions of the Software. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, WRISING FROM, // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN // THE SOFTWARE // // @license: http://www.opensource.org/licenses/mit-license.php // @author: see AUTHORS file #pragma once #include <functional> #include <iterator> #include <map> #include <memory> #include <string> #include <unordered_map> #include <utility> #include <vector> #include <xlnt/xlnt_config.hpp> #include <xlnt/cell/rich_text.hpp> namespace xlnt { enum class calendar; enum class core_property; enum class extended_property; enum class relationship_type; class alignment; class border; class calculation_properties; class cell; class cell_style; class color; class const_worksheet_iterator; class drawing; class fill; class font; class format; class rich_text; class manifest; class metadata_property; class named_range; class number_format; class path; class pattern_fill; class protection; class range; class range_reference; class relationship; class streaming_workbook_reader; class style; class style_serializer; class theme; class variant; class workbook_view; class worksheet; class worksheet_iterator; class zip_file; struct datetime; namespace detail { struct stylesheet; struct workbook_impl; class xlsx_consumer; class xlsx_producer; } // namespace detail /// <summary> /// workbook is the container for all other parts of the document. /// </summary> class XLNT_API workbook { public: /// <summary> /// typedef for the iterator used for iterating through this workbook /// (non-const) in a range-based for loop. /// </summary> using iterator = worksheet_iterator; /// <summary> /// typedef for the iterator used for iterating through this workbook /// (const) in a range-based for loop. /// </summary> using const_iterator = const_worksheet_iterator; /// <summary> /// typedef for the iterator used for iterating through this workbook /// (non-const) in a range-based for loop in reverse order using /// std::make_reverse_iterator. /// </summary> using reverse_iterator = std::reverse_iterator<iterator>; /// <summary> /// typedef for the iterator used for iterating through this workbook /// (const) in a range-based for loop in reverse order using /// std::make_reverse_iterator. /// </summary> using const_reverse_iterator = std::reverse_iterator<const_iterator>; /// <summary> /// Constructs and returns an empty workbook similar to a default. /// Excel workbook /// </summary> static workbook empty(); // Constructors /// <summary> /// Default constructor. Constructs a workbook containing a single empty /// worksheet using workbook::empty(). /// </summary> workbook(); /// <summary> /// load the xlsx file at path /// </summary> workbook(const xlnt::path &file); /// <summary> /// load the encrpyted xlsx file at path /// </summary> workbook(const xlnt::path &file, const std::string& password); /// <summary> /// construct the workbook from any data stream where the data is the binary form of a workbook /// </summary> workbook(std::istream & data); /// <summary> /// construct the workbook from any data stream where the data is the binary form of an encrypted workbook /// </summary> workbook(std::istream &data, const std::string& password); /// <summary> /// Move constructor. Constructs a workbook from existing workbook, other. /// </summary> workbook(workbook &&other); /// <summary> /// Copy constructor. Constructs this workbook from existing workbook, other. /// </summary> workbook(const workbook &other); /// <summary> /// Destroys this workbook, deallocating all internal storage space. Any pimpl /// wrapper classes (e.g. cell) pointing into this workbook will be invalid /// after this is executed. /// </summary> ~workbook(); // Worksheets /// <summary> /// Creates and returns a sheet after the last sheet in this workbook. /// </summary> worksheet create_sheet(); /// <summary> /// Creates and returns a sheet at the specified index. /// </summary> worksheet create_sheet(std::size_t index); /// <summary> /// TODO: This should be private... /// </summary> worksheet create_sheet_with_rel(const std::string &title, const relationship &rel); /// <summary> /// Creates and returns a new sheet after the last sheet initializing it /// with all of the data from the provided worksheet. /// </summary> worksheet copy_sheet(worksheet worksheet); /// <summary> /// Creates and returns a new sheet at the specified index initializing it /// with all of the data from the provided worksheet. /// </summary> worksheet copy_sheet(worksheet worksheet, std::size_t index); /// <summary> /// Returns the worksheet that is determined to be active. An active /// sheet is that which is initially shown by the spreadsheet editor. /// </summary> worksheet active_sheet(); /// <summary> /// Returns the worksheet with the given name. This may throw an exception /// if the sheet isn't found. Use workbook::contains(const std::string &) /// to make sure the sheet exists before calling this method. /// </summary> worksheet sheet_by_title(const std::string &title); /// <summary> /// Returns the worksheet with the given name. This may throw an exception /// if the sheet isn't found. Use workbook::contains(const std::string &) /// to make sure the sheet exists before calling this method. /// </summary> const worksheet sheet_by_title(const std::string &title) const; /// <summary> /// Returns the worksheet at the given index. This will throw an exception /// if index is greater than or equal to the number of sheets in this workbook. /// </summary> worksheet sheet_by_index(std::size_t index); /// <summary> /// Returns the worksheet at the given index. This will throw an exception /// if index is greater than or equal to the number of sheets in this workbook. /// </summary> const worksheet sheet_by_index(std::size_t index) const; /// <summary> /// Returns the worksheet with a sheetId of id. Sheet IDs are arbitrary numbers /// that uniquely identify a sheet. Most users won't need this. /// </summary> worksheet sheet_by_id(std::size_t id); /// <summary> /// Returns the worksheet with a sheetId of id. Sheet IDs are arbitrary numbers /// that uniquely identify a sheet. Most users won't need this. /// </summary> const worksheet sheet_by_id(std::size_t id) const; /// <summary> /// Returns true if this workbook contains a sheet with the given title. /// </summary> bool contains(const std::string &title) const; /// <summary> /// Returns the index of the given w