我的vsflexgrid表格中的列大概有500来个,在我用vsflexgrid.SaveGrid (App.Path & "\e4.xls"), flexFileCustomText, True ' 的方法时候,导出的只是其中的一部分,其他的为什么导不出来呢?怪了。大家看看拉。
解决方案 »
- 本人在学COM知识,请相关人士介绍几本基础知识的书或相关视频
- VSFlexGrid修改关联表问题
- 请问如何将多个数组合并为一个数组?
- SetEnhMetaFileBits函数编译前成功,编译后的程序失败,原因?
- =========入门问题:如何组织数据?========
- 如何显示单词音标?
- 有关MSFLEXGIRD控件的问题
- 看到一本书上讲,如果在click事件中有编码,DlbClik事件永远不会触发(visual basic 6.0高级编程技巧--控件篇)西安交大出版,是这样的吗
- 如何建立拷贝钩子?
- vb问题集vb高手快来看啊!
- 如何让PictureBox之类的控件的背景变为透明??
- RegEnumKeyEx出现87号错误怎样解决
最大列数:256
最大行数:65536
你有500列当然没法完全载入啦
可以在文件前面加上时间串
format(now,"yyyymmddhhmmss")
Value
Description
flexFileAll
0
Save all data and formatting information.
flexFileData
1
Save only the data, ignoring formatting information.
flexFileFormat
2
Save only the global formatting, ignoring the data.
flexFileCommaText
3
Save data to a comma-delimited text file.
flexFileTabText
4
Save data to a tab-delimited text file.
flexFileCustomText
5
Save data to a text file using the delimiters specified by the ClipSeparators property.
flexFileExcel
6
Save all data and formatting information to an Excel97 file. This filter does not support frozen color rows or columns.
Options As Variant (optional)When saving and loading text files, this parameter allows you to specify whether fixed cells are saved and restored. The default is False, which means fixed cells are not saved or restored.When saving and loading Excel files, this parameter allows you to specify the name or index of the sheet to be loaded, or the name of the sheet to be saved. If omitted, the first sheet is loaded.The options for saving fixed rows, columns, and translated combo values include: Constant
Value
Description
flexXLSaveFixedCells
3
Saves fixed cells.
flexXLSaveFixedRows
2
Saves fixed rows.
flexXLSaveFixedCols
1
Saves fixed columns.
flexXLSaveRaw
4
Saves raw (untranslated) data.
For example, the options can be written as:fg.SaveGrid "book1.xls", flexFileExcelfg.SaveGrid "book1.xls", flexFileExcel, "sheetName"fg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedCellsfg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedRowsfg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveFixedColsfg.SaveGrid "book1.xls", flexFileExcel, flexXLSaveRawfg.SaveGrid "book1.xls", flexFileExcel, _
flexXLSaveFixedCells Or flexXLSaveRawNotesThe flexFileFormat option saves global formatting only. It does not save any cell-specific information, not even the number of rows and columns. This allows you to use this setting to create formats that can be applied to existing grids even if they have different dimensions. Because column widths and row heights are related to the number of rows and columns on the grid, they are not saved or restored if you use the flexFileFormat option. The following is a list of the properties that do get saved and restored if you use the flexFileFormat option: BackColor, ForeColor, BackColorBkg, BackColorAlternate, BackColorFixed, ForeColorFixed, BackColorSel, ForeColorSel, TreeColor, SheetBorder, GridLines, GridLinesFixed, GridLineWidth, GridColor, GridColorFixed, TextStyle, TextStyleFixed, ScrollBars, SelectionMode, RowHeightMin, MergeCells, SubtotalPosition, OutlineBar, Font, and WordWrap.If your application requires you to save several grids, you should consider using the Archive method to compress and combine them all into a single archive file. You can later use the ArchiveInfo method to retrieve information from the archive file.The flexFileExcel option is new in Version 8. It does not require Excel to be present on the machine. You can load and save Excel97 sheets (BIFF9 format), one sheet per workbook only (when loading, you can specify which sheet using the Options parameter).The Excel filter supports cell values (including formula values), fonts, formats, colors, row and column dimensions. Several improvements have been made so that it now also supports more than 30k rows, word-wrapping and all ColorAlternate and ColorFrozen properties. It does not support features that don't translate into the grid, such as macros, charts, rotated text, cell borders, and other advanced formatting.Starting in build 200, the control also recognizes a string parameter when saving/loading text files. If the string contains an 'f', fixed cells will be included when saving/loading. If the string contains a 'v', only visible cells will be saved to the text files. For example:fg.SaveGrid "book1.csv", flexFileCommaText, "fv"
不是改成TRUE 就是FALSE
给分吧