VSFlexGrid导出EXCEL后,在本机上数据的排版和预览的一样,但是在同事的机子上就出现怪事,很多行与行间插入了许多合并的空白行,请问其他朋友有没有碰到这样的问题,如何解决?
解决方案 »
- vb6 rs记录集,怎么取其中的一段记录
- 征集:让VB6代码窗口支持鼠标的最佳方法 .如果自己写代码实现+70分
- 如何得到当前进程的父进程?
- 哎,CoderHelper 终于可以正式发布了,也不知道大家喜不喜欢它,如果有兴趣你给看看把!
- 一个半月,马甲也升星了。散~~
- ComboBox问题 急急
- 我用VB写的程序,调用了其他应用程序,想让我的窗口隐藏起来,在调用的应用程序起来后关闭我自己的程序,如何实现?
- ★★★求助!一个简单的编程题
- 用VB打开数据库时workspace,databse是如何使用的???
- 如何用数据库B的字段去更新数据库A的字段?
- 一段有趣的网络代码,在运行后才看到结果,谁可以分析出来(会html语言的请进)
- 制作属性窗口
下面是有关savegrid的帮助说明.SaveGrid MethodSaves grid contents and format to a file.
Syntax
[form!]VSFlexGrid.SaveGrid FileName As String, SaveWhat As SaveLoadSettings, [ FixedCells As Boolean ]
Res
This method saves a grid to a binary or to a text file. The grid may be retrieved later with the LoadGrid method. Grids saved to text files may also be read by other programs, such as Microsoft Excel or Microsoft Word.The parameters for the SaveGrid method are described below:FileName As String
The name of the file to create, including the path. If a file with the same name already exists, it is overwritten.SaveWhat As SaveLoadSettings
This parameter specifies what should be saved. Valid options are:Constant 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.
FixedCells As Variant (optional)
If this parameter is set to False (the default), then values in fixed cells are not saved to text files -- only the scrollable part of the grid is saved. If this parameter is set to True, then fixed rows and columns are also saved.The 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.
email: [email protected]
先謝過了!!
可以给一个下载的地址吗?另外,有关vsprint中自定义纸张如何设定?请指点,困挠许久了,请教了太多的高手至今仍没有解决啊,郁闷的很啊?
先谢过!
不好意思,我也是刚接触VSFLEX,没什么好的资料.
这个问题,我也遇到过