#include?“c_excel.h“

c_excel::c_excel（Qobject?*parent）
	:?Qobject（parent）
{

}

c_excel::~c_excel（）
{

}

void?c_excel::Slot_Read_Excel_File（）
{
	QXlsx::Document?xlsx（EXCEL_PATH）;
	QXlsx::CellRange?range?=?xlsx.dimension（）;
	int?nrow?=?range.lastRow（）;
	//int?ncol?=?range.lastColumn（）;

	for?（int?i?=?0;?i?	{
		QString?qstrip?=?xlsx.read（i+21）.toString（）;
		QString?qstrrtsp1?=?xlsx.read（i+22）.toString（）;
		QString?qstrrtsp2?=?xlsx.read（i+23）.toString（）;
		QString?qstruser?=?xlsx.read（i+24）.toString（）;

		if?（qstrip.isEmpty（））
		{
			continue;
		}

	}
}

void?c_excel::Slot_Write_Excel_File（）
{
	QXlsx::Document?xlsx;
	QXlsx::Format?format;???
	format.setHorizontalAlignment（QXlsx::Format::AlignHCenter）;
	format.setVerticalAlignment（QXlsx::Format::AlignVCenter）;
	xlsx.setColumnWidth（360）;
	xlsx.write（“A1“tr（“Device“）format）;
	xlsx.write（“B1“tr（“State“）format）;
	xlsx.write（“C1“tr（“Question“）format）;
	xlsx.write（“D1“tr（“Time“）format）;

	int?nCount?=?EXCEL_COUNT;
	static?int?gnCount?=?0;
	for?（int?i?=?0;?i?	{
		char?buff[100];
		memset（buff0sizeof（buff））;
		sprintf（buff“IPC%d“++?gnCount）;
		xlsx.write（i+21buffformat）;
		memset（buff0sizeof（buff））;
		sprintf（buff“State:?%d“gnCount）;
		xlsx.write（i+22buffformat）;
		memset（buff0sizeof（buff））;
		sprintf（buff“1111111111111111111111111111Question:?%d“gnCount）;
		xlsx.write（i+23buffformat）;
		memset（buff0sizeof（buff））;
		sprintf（buff“111111111111111111Time:?%d“gnCount）;
		xlsx.write（i+24buffformat）;

	}
	bool?bret?=?xlsx.saveAs（EXCEL_PATH）;
	QXlsx::Document?xlsx2（EXCEL_PATH）;/*復制A到B*/
	xlsx2.saveAs（“B.xlsx“）;
	if?（bret）
	{
		emit?signal_save_success（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-08?19:08??Excel_test\
?????目錄???????????0??2017-11-08?19:09??Excel_test\Excel_test\
?????文件?????????897??2017-11-07?16:11??Excel_test\Excel_test.sln
?????文件????????1770??2017-11-08?19:05??Excel_test\Excel_test\c_excel.cpp
?????文件?????????609??2017-11-08?16:04??Excel_test\Excel_test\c_excel.h
?????文件?????????530??2017-11-08?17:05??Excel_test\Excel_test\Excel_test.pri
?????文件?????????680??2017-11-08?17:06??Excel_test\Excel_test\Excel_test.pro
?????文件???????18785??2017-11-08?17:01??Excel_test\Excel_test\Excel_test.pro.user
?????文件???????13722??2017-11-08?17:20??Excel_test\Excel_test\Excel_test.vcxproj
?????文件????????3117??2017-11-07?16:26??Excel_test\Excel_test\Excel_test.vcxproj.filters
?????文件?????????605??2017-11-07?16:26??Excel_test\Excel_test\Excel_test.vcxproj.user
?????目錄???????????0??2017-11-08?19:08??Excel_test\Excel_test\GeneratedFiles\
?????目錄???????????0??2017-11-08?19:08??Excel_test\Excel_test\GeneratedFiles\Debug\
?????文件????????4369??2017-11-08?18:54??Excel_test\Excel_test\GeneratedFiles\Debug\moc_c_excel.cpp
?????文件????????2628??2017-11-08?18:54??Excel_test\Excel_test\GeneratedFiles\Debug\moc_widget.cpp
?????文件????????1390??2017-11-08?18:54??Excel_test\Excel_test\GeneratedFiles\qrc_widget.cpp
?????目錄???????????0??2017-11-07?16:11??Excel_test\Excel_test\GeneratedFiles\Release\
?????文件????????1894??2017-11-08?18:54??Excel_test\Excel_test\GeneratedFiles\ui_widget.h
?????文件?????????173??2017-11-08?13:50??Excel_test\Excel_test\main.cpp
?????目錄???????????0??2017-11-07?16:11??Excel_test\Excel_test\Resources\
?????文件?????????408??2017-11-08?16:20??Excel_test\Excel_test\widget.cpp
?????文件?????????336??2017-11-08?16:16??Excel_test\Excel_test\widget.h
?????文件??????????66??2017-11-07?16:11??Excel_test\Excel_test\widget.qrc
?????文件????????1076??2017-11-08?16:14??Excel_test\Excel_test\widget.ui