Qtablewidget Export to CSV table

Job-hopping to the new company, began to work the site development, access to new applications. There are many applications that need to export tables to a table, and you can export the table to a file in CSV format. Share with the rest of the crowd;

[CPP]View PlainCopy 

2. Lass tabletoexcle: public qdialog
4. {
6. Q_object
10. Public
12. Tabletoexcle (Qwidget *parent = 0, Qt::wflags flags = 0);
14. ~tabletoexcle ();
18. Private
20. Ui::tabletoexcleclass UI;
22. Private Slots:
24. void Addrowslot ();
26. void Delrowslot ();
28. void Exportslot ();
30. };

[CPP]View PlainCopy 

2. Tabletoexcle::tabletoexcle (Qwidget *parent, qt::wflags flags)
4. : Qdialog (parent, flags)
6. {
8. UI.SETUPUI (this);
10. Ui.m_ptable->setcolumncount (4);
12. Qtablewidgetitem * item = new Qtablewidgetitem ("0");
14. Ui.m_ptable->sethorizontalheaderitem (0, item);
16. item = New Qtablewidgetitem ("1");
18. Ui.m_ptable->sethorizontalheaderitem (1, item);
20. item = New Qtablewidgetitem ("2");
22. Ui.m_ptable->sethorizontalheaderitem (2, item);
24. item = New Qtablewidgetitem ("3");
26. Ui.m_ptable->sethorizontalheaderitem (3, item);
28. Ui.m_ptable->setselectionbehavior (qabstractitemview::selectrows);
30. Connect (ui.m_paddbtn,signal (clicked ()),This,slot (Addrowslot ()));
32. Connect (ui.m_pdelbtn,signal (clicked ()),This,slot (Delrowslot ()));
34. Connect (ui.m_pexportbtn,signal (clicked ()),This,slot (Exportslot ()));
36. }
40. Tabletoexcle::~tabletoexcle ()
42. {
46. }
50. void Tabletoexcle::addrowslot ()
52. {
54. Ui.m_ptable->insertrow (Ui.m_ptable->rowcount ());
58. }
62. void Tabletoexcle::d elrowslot ()
64. {
66. int index = Ui.m_ptable->currentrow ();
68. if (Index >-1)
70. {
72. Ui.m_ptable->removerow (index);
74. }
76. }
80. void Tabletoexcle::exportslot ()
82. {
84. QString FileName = Qfiledialog::getsavefilename (This, tr ("Save file"), "", tr ("file (*.csv)");
86. if (!filename.isempty ())
88. {
90. QFile file (fileName);
92. BOOL ret = File.Open (qiodevice::truncate |  QIODEVICE::WRITEONLY);
94. if (!ret)
96. return;
100. Qtextstream Stream (&file);
102. QString conTents;
104. Qheaderview * Header = Ui.m_ptable->horizontalheader ();
106. if (header)
108. {
110. For ( int i = 0; i < Header->count (); i++)
112. {
114. Qtablewidgetitem *item = Ui.m_ptable->horizontalheaderitem (i);
116. if (!item)
118. {
120. continue;
122. }
124. ConTents + = Item->text () + ",";
126. }
128. ConTents + = "\ n";
130. }
134. For ( int i = 0; i < Ui.m_ptable->rowcount (); i++)
136. {
138. For ( int j = 0; J < Ui.m_ptable->columncount (); j + +)
140. {
144. qtablewidgetitem* item = Ui.m_ptable->item (i, j);
146. if (!item)
148. continue;
150. QString str = Item->text ();
152. Str.replace (",", "");
154. ConTents + = str + ",";
156. }
158. ConTents + = "\ n";
160. }
162. Stream << conTents;
164. File.close ();
166. }
168. if (Qmessagebox::yes = = Qmessagebox::information (0,qobject::tr ("File Export"), QString ("file export succeeded, do you want to open the file?") "), Qmessagebox::yes,qmessagebox::no))
170. {
174. Qsettings settings ("Hkey_local_machine\\software\\microsoft\\office", Qsettings::nativeformat);
176. QString Szdefault, szpath;
178. BOOL bsuccess;
180. Szpath = Settings.value ("12.0/excel/installroot/path"). ToString ();
182. if (Szpath.isempty ())
184. Szpath = Settings.value ("11.0/excel/installroot/path"). ToString ();
186. if (Szpath.isempty ())
188. Szpath = Settings.value ("10.0/excel/installroot/path"). ToString ();
190. if (Szpath.isempty ())
192. Szpath = Settings.value ("9.0/excel/installroot/path"). ToString ();
194. if (Szpath.isempty ())
196. Szpath = Settings.value ("14.0/excel/installroot/path"). ToString ();
200. if (Szpath.isempty ())
202. {
204. Qmessagebox::information (0, "prompt", "the system does not have Office installed, cannot view the failure report, please install Microsoft Office first.");
206. return;
208. }
212. qprocess * proce = new qprocess;
214. QString Szexcelexe = szpath + "Excel.exe";
216. QString Szopen = "/safe";
218. QString Szdoc = fileName;
220. Qstringlist list;
222. list<<szdoc;
224. if (proce)
226. {
228. Proce->start (szexcelexe,list);
230. proce->waitforstarted (5000); //need to wait for the boot to complete
232. }<pre name="code" class="cpp" > delete proce;

http://blog.csdn.net/hai200501019/article/details/37538591

Qtablewidget Export to CSV table