:
xlnt_demo，利用C++开源库xlnt读写excel，vs2015工程
资源介绍:
利用C++开源库xlnt读写excel的vs2015工程。详细教程参考博客：https://humfrey.blog.csdn.net/article/details/107527883
#include
#include
#include
#include
void read_to_screen(std::string filepath)
{
xlnt::workbook wb;
wb.load(filepath);
auto ws = wb.active_sheet();
std::clog << "Processing spread sheet" << std::endl;
// 会把当前占用的单元格全都打印出来，空单元格则为空格。
for (auto row : ws.rows(false))
{
for (auto cell : row)
{
std::clog << cell.to_string() << "\t";
}
std::clog << std::endl;
}
std::clog << "Processing complete" << std::endl;
}
std::vector< std::vector > read_to_vector(std::string filepath)
{
xlnt::workbook wb;
wb.load(filepath);
auto ws = wb.active_sheet();
std::clog << "Processing spread sheet" << std::endl;
std::clog << "Creating a single vector which stores the whole spread sheet" << std::endl;
std::vector< std::vector > theWholeSpreadSheet;
for (auto row : ws.rows(false))
{
std::vector aSingleRow;
for (auto cell : row)
{
aSingleRow.push_back(cell.to_string());
}
theWholeSpreadSheet.push_back(aSingleRow);
}
std::clog << "Processing complete" << std::endl << std::endl;
std::clog << "Reading the vector and printing output to the screen" << std::endl;
for (int rowInt = 0; rowInt < theWholeSpreadSheet.size(); rowInt++)
{
for (int colInt = 0; colInt < theWholeSpreadSheet.at(rowInt).size(); colInt++)
{
std::cout << theWholeSpreadSheet.at(rowInt).at(colInt) << "\t";
}
std::cout << std::endl;
}
return theWholeSpreadSheet;
}
void save_demo(std::string filepath)
{
xlnt::workbook wb;
xlnt::worksheet ws = wb.active_sheet();
//赋值为数值
ws.cell("A1").value(0.5);
//设置单位格格式，设为百分比形式
ws.cell("A1").number_format(xlnt::number_format::percentage());
//赋值为字符串
ws.cell("B2").value("string data");
//赋值为公式
ws.cell("C3").formula("=RAND()");
//合并单元格
ws.merge_cells("C3:C4");
//冻结窗格
ws.freeze_panes("B2");
//保存
wb.save(filepath);
}
void save_from_vector(std::string filepath)
{
std::vector< std::vector > wholeWorksheet;
for (int outer = 0; outer < 10; outer++)
{
std::vector singleRow;
for (int inner = 0; inner < 10; inner++)
{
//给vector中的每个元素赋值
std::string val = std::to_string(inner + 1);
singleRow.push_back(val);
}
wholeWorksheet.push_back(singleRow);
}
//创建工作簿
std::clog << "Creating workbook" << std::endl;
xlnt::workbook wbOut;
//创建工作表，并把vector中的元素写入表格
xlnt::worksheet wsOut = wbOut.active_sheet();
//给工作表设置名称
wsOut.title("data");
std::clog << "Looping through vector and writing to spread sheet" << std::endl;
for (int fOut = 0; fOut < wholeWorksheet.size(); fOut++)
{
std::clog << "Row" << fOut << std::endl;
for (int fIn = 0; fIn < wholeWorksheet.at(fOut).size(); fIn++)
{
// 给单元格赋值
// 特别注意：工作表中的单元格下标是从1开始，而vector中的元素下标是从0开始
wsOut.cell(xlnt::cell_reference(fIn + 1, fOut + 1)).value(wholeWorksheet.at(fOut).at(fIn));
}
}
std::clog << "Finished writing spread sheet" << std::endl;
wbOut.save(filepath);
}
int main()
{
//read_to_screen("test_read.xlsx");
//read_to_vector("test_read.xlsx");
//save_demo("test_save.xlsx");
save_from_vector("test_save.xlsx");
getchar();
return 0;
}
资源文件列表:
xlnt_demo.zip 大约有122个文件
xlnt_demo/- xlnt_demo/x64/
- xlnt_demo/x64/Release/
xlnt_demo/x64/Release/xlnt.dll 1.82MB
- xlnt_demo/x64/Release/xlnt_demo.exe 23.5KB
- xlnt_demo/x64/Release/xlnt_demo.iobj 609.91KB
- xlnt_demo/x64/Release/xlnt_demo.ipdb 198.89KB
- xlnt_demo/x64/Release/xlnt_demo.pdb 1.41MB
- xlnt_demo/xlnt_demo/
- xlnt_demo/xlnt_demo/bin/
- xlnt_demo/xlnt_demo/bin/xlnt.dll 1.82MB
- xlnt_demo/xlnt_demo/include/
- xlnt_demo/xlnt_demo/include/xlnt/
- xlnt_demo/xlnt_demo/include/xlnt/cell/
- xlnt_demo/xlnt_demo/include/xlnt/cell/cell.hpp 21.06KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/cell_reference.hpp 9.62KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/cell_type.hpp 2.04KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/comment.hpp 4.7KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/hyperlink.hpp 2.2KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/index_types.hpp 9.99KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/phonetic_run.hpp 1.6KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/rich_text.hpp 5.58KB
- xlnt_demo/xlnt_demo/include/xlnt/cell/rich_text_run.hpp 1.71KB
- xlnt_demo/xlnt_demo/include/xlnt/drawing/
- xlnt_demo/xlnt_demo/include/xlnt/drawing/spreadsheet_drawing.hpp 1.89KB
- xlnt_demo/xlnt_demo/include/xlnt/packaging/
- xlnt_demo/xlnt_demo/include/xlnt/packaging/ext_list.hpp 2.71KB
- xlnt_demo/xlnt_demo/include/xlnt/packaging/manifest.hpp 7.56KB
- xlnt_demo/xlnt_demo/include/xlnt/packaging/relationship.hpp 5KB
- xlnt_demo/xlnt_demo/include/xlnt/packaging/uri.hpp 6.76KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/
- xlnt_demo/xlnt_demo/include/xlnt/styles/alignment.hpp 4.92KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/border.hpp 6.12KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/color.hpp 9.7KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/conditional_format.hpp 4.33KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/fill.hpp 9.93KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/font.hpp 8.51KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/format.hpp 7.52KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/number_format.hpp 7.75KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/protection.hpp 3.4KB
- xlnt_demo/xlnt_demo/include/xlnt/styles/style.hpp 8.34KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/
- xlnt_demo/xlnt_demo/include/xlnt/utils/calendar.hpp 1.5KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/date.hpp 2.92KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/datetime.hpp 4.08KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/exceptions.hpp 9.1KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/numeric.hpp 6.87KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/optional.hpp 10.73KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/path.hpp 6.89KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/scoped_enum_hash.hpp 1.76KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/time.hpp 3.03KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/timedelta.hpp 2.55KB
- xlnt_demo/xlnt_demo/include/xlnt/utils/variant.hpp 5.12KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/
- xlnt_demo/xlnt_demo/include/xlnt/workbook/calculation_properties.hpp 2.06KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/document_security.hpp 3.34KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/external_book.hpp 1.46KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/metadata_property.hpp 2.26KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/named_range.hpp 2.99KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/streaming_workbook_reader.hpp 4.67KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/streaming_workbook_writer.hpp 3.84KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/theme.hpp 1.54KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/workbook.hpp 30.02KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/workbook_view.hpp 3.92KB
- xlnt_demo/xlnt_demo/include/xlnt/workbook/worksheet_iterator.hpp 8.73KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/cell_iterator.hpp 9.98KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/cell_vector.hpp 7.01KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/column_properties.hpp 2.49KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/header_footer.hpp 10.49KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/major_order.hpp 1.46KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/page_margins.hpp 3.46KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/page_setup.hpp 5.69KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/pane.hpp 2.89KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/phonetic_pr.hpp 4.5KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/print_options.hpp 2.37KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/range.hpp 9.74KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/range_iterator.hpp 8.49KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/range_reference.hpp 6.4KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/row_properties.hpp 2.88KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/selection.hpp 4.61KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_format_properties.hpp 2.29KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_pr.hpp 3.11KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_protection.hpp 2.15KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_view.hpp 6.75KB
- xlnt_demo/xlnt_demo/include/xlnt/worksheet/worksheet.hpp 26.05KB
- xlnt_demo/xlnt_demo/include/xlnt/xlnt.hpp 3.41KB
- xlnt_demo/xlnt_demo/include/xlnt/xlnt_config.hpp 1.6KB
- xlnt_demo/xlnt_demo/lib/
- xlnt_demo/xlnt_demo/lib/cmake/
- xlnt_demo/xlnt_demo/lib/cmake/xlnt/
- xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntConfig.cmake 1.15KB
- xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntConfigVersion.cmake 1.84KB
- xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntTargets-release.cmake 866B
- xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntTargets.cmake 3.25KB
- xlnt_demo/xlnt_demo/lib/xlnt.lib 615.39KB
- xlnt_demo/xlnt_demo/main.cpp 3.28KB
- xlnt_demo/xlnt_demo/share/
- xlnt_demo/xlnt_demo/share/man/
- xlnt_demo/xlnt_demo/share/man/man3/
- xlnt_demo/xlnt_demo/share/man/man3/xlnt.3 63.18KB
- xlnt_demo/xlnt_demo/test_read.xlsx 8.67KB
- xlnt_demo/xlnt_demo/test_save.xlsx 12.84KB
- xlnt_demo/xlnt_demo/x64/
- xlnt_demo/xlnt_demo/x64/Release/
- xlnt_demo/xlnt_demo/x64/Release/main.obj 1.32MB
- xlnt_demo/xlnt_demo/x64/Release/vc140.pdb 1.07MB
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.Build.CppClean.log 637B
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.log 449B
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.command.1.tlog 656B
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.read.1.tlog 26.77KB
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.write.1.tlog 354B
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.command.1.tlog 1.28KB
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.read.1.tlog 3.74KB
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.write.1.tlog 588B
- xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/xlnt_demo.lastbuildstate 196B
- xlnt_demo/xlnt_demo/xlnt.dll 1.82MB
- xlnt_demo/xlnt_demo/xlnt_demo.vcxproj 5.95KB
- xlnt_demo/xlnt_demo/xlnt_demo.vcxproj.filters 945B
- xlnt_demo/xlnt_demo/xlnt_demo.vcxproj.user 165B
- xlnt_demo/xlnt_demo.sln 1.28KB
找了两三天，得到所有openfire3.10.2缺失jar包，包含7个，导入到工程即可。期间遇到很多问题，比如无法找到HTTPSPDYServerConnector类等，都已经能够解决了。
本文件是MSP430F5529的官方例程，虽然在官网上可以找到，但是很不好找，里面有十几个实验例程，注意代码是在solution这个文件夹里面
64位运行库
SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
CXF整合Spring需要用到的JAR包
落雪音乐自定义音源切换
usbcan(c#实例)解决了一次只能接受一条数据的问题
基于博图1200系列制作的多站轮询减低编程压力，提高编程效率，帮助新手过渡
获取相对XPath、绝对XPath和CSS选择器。编辑、检查和验证DevTools面板本身中的XPath和CSS选择器。