📄 scip_be - components tscexcelexport.htm
字号:
border=0></A> <A class=small
href="http://www.scip.be/RSS/ScipNews.xml" target=_blank><IMG
src="SCIP_be - Components TscExcelExport_bestanden/RSS2.png"
border=0></A>
</DIV></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV class=frameright><BR>
<TABLE class=tabsmall width=130>
<TBODY>
<TR>
<TD>
<TABLE height=24 cellPadding=0 width="100%" border=0 celspacing="0">
<TBODY>
<TR class=smallbold>
<TD width=28><SPAN
style="DISPLAY: inline; FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='Images/IconComponent24.png',sizingMethod='scale'); WIDTH: 24px; POSITION: absolute; HEIGHT: 24px"></SPAN><IMG
height=24 alt=.
src="SCIP_be - Components TscExcelExport_bestanden/Blank.gif"
width=24 border=0></TD>
<TD>Components</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=small width=130>
<TBODY>
<TR class=small>
<TD><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=Components&Lang=EN"
target=_top>Overview</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmallRed.jpg"
border=0> <A class=selectedsmall><A
href="http://www.scip.be/index.php?Page=ComponentsExcelExport&Lang=EN"
target=_top><B><FONT
color=#98274f>TscExcelExport</FONT></B></A></A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsFontCombobox&Lang=EN"
target=_top>TscFontCombobox</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsDataList&Lang=EN"
target=_top>TscDataList</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsFileDrop&Lang=EN"
target=_top>TscFileDrop</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsSystemInfo&Lang=EN"
target=_top>TscSystemInfo</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsScrollingText&Lang=EN"
target=_top>TscScrollingText</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsLinkLabel&Lang=EN"
target=_top>TscLinkLabel</A><BR></TD></TR></TBODY></TABLE><BR>
<TABLE class=tabsmall width=130>
<TBODY>
<TR>
<TD>
<TABLE height=24 cellPadding=0 width="100%" border=0 celspacing="0">
<TBODY>
<TR class=smallbold>
<TD width=28><SPAN
style="DISPLAY: inline; FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='Images/IconNews24.png',sizingMethod='scale'); WIDTH: 24px; POSITION: absolute; HEIGHT: 24px"></SPAN><IMG
height=24 alt=.
src="SCIP_be - Components TscExcelExport_bestanden/Blank.gif"
width=24></TD>
<TD>New</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=small width=130>
<TBODY>
<TR class=small>
<TD><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsExcelExport&Lang=EN"
target=_top>New version TscExcelExport</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=PhotosPatagonia&Lang=EN"
target=_top>Photos Patagonia</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=PhotosMacro&Lang=EN"
target=_top>New macro photos</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ArticlesDelphi15&Lang=EN"
target=_top>Article Delphi .NET Compact Framework</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ArticlesDelphi14&Lang=EN"
target=_top>Article Delphi tools & VBScripts</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=PhotosAndalucia&Lang=EN"
target=_top>Photos Andalusia</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=PhotosPanorama&Lang=EN"
target=_top>Panoramic pictures</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsExcelExport&Lang=EN"
target=_top>New version TscExcelExport</A><BR></TD></TR></TBODY></TABLE><BR>
<TABLE class=tabsmall width=130>
<TBODY>
<TR>
<TD>
<TABLE height=24 cellPadding=0 width="100%" border=0 celspacing="0">
<TBODY>
<TR class=smallbold>
<TD width=28><SPAN
style="DISPLAY: inline; FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='Images/IconLanguage24.png',sizingMethod='scale'); WIDTH: 24px; POSITION: absolute; HEIGHT: 24px"></SPAN><IMG
height=24 alt=.
src="SCIP_be - Components TscExcelExport_bestanden/Blank.gif"
width=24></TD>
<TD>Language</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=small width=130>
<TBODY>
<TR class=small>
<TD><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A
href="http://www.scip.be/index.php?Page=ComponentsExcelExport&Lang=NL"
target=_top>Nederlands</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmallRed.jpg"
border=0> <A class=selectedsmall>English</A></TD></TR></TBODY></TABLE><BR>
<TABLE class=tabsmall width=130>
<TBODY>
<TR>
<TD>
<TABLE height=24 cellPadding=0 width="100%" border=0 celspacing="0">
<TBODY>
<TR class=smallbold>
<TD width=28><SPAN
style="DISPLAY: inline; FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='Images/IconURL24.png',sizingMethod='scale'); WIDTH: 24px; POSITION: absolute; HEIGHT: 24px"></SPAN><IMG
height=24 alt=.
src="SCIP_be - Components TscExcelExport_bestanden/Blank.gif"
width=24></TD>
<TD>Websites</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE class=small width=130>
<TBODY>
<TR class=small>
<TD><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A href="http://www.delphiabc.com/" target=_blank>Delphi
ABC</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A href="http://www.delphicity.net/" target=_blank>Delphi
City</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A href="http://delphi.icm.edu.pl/" target=_blank>Delphi Super
Page</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A href="http://www.delphi-jedi.org/" target=_blank>Project
JEDI</A><BR><IMG
src="SCIP_be - Components TscExcelExport_bestanden/BulletSmall.jpg"
border=0> <A href="http://www.torry.net/" target=_blank>Torry's Delphi
Pages</A><BR></TD></TR></TBODY></TABLE><BR>
<TABLE class=small width=130>
<TBODY>
<TR class=small>
<TD width=125><IMG
src="SCIP_be - Components TscExcelExport_bestanden/Banner.gif" border=0>
</TD></TR></TBODY></TABLE><BR></DIV>
<DIV class=framecenter>
<H1>Components : TscExcelExport</H1>
<P><SPAN
style="DISPLAY: inline; FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='Images/Line.png',sizingMethod='scale'); WIDTH: 417px; POSITION: absolute; HEIGHT: 20px"></SPAN><IMG
height=20 alt=. src="SCIP_be - Components TscExcelExport_bestanden/Blank.gif"
width=417></P>
<H6><IMG height=40
src="SCIP_be - Components TscExcelExport_bestanden/ComponentsExcelExport2.jpg"
width=40> Version 3.4 (April 2006, freeware for non-commercial use, VCL)</H6>
<P>This TscExcelExport component is an advanced, powerful but easy component to
export all records of a dataset from Delphi to MS Excel (97, 2000, XP or 2003).
Many features are provided to change the layout, to add totals, to create
groups, ...</P>
<P><IMG height=270
src="SCIP_be - Components TscExcelExport_bestanden/ComponentsExcelExport07.jpg"
width=583><BR></P>
<TABLE width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top width=300><IMG
src="SCIP_be - Components TscExcelExport_bestanden/ComponentsExcelExport01.jpg"></TD>
<TD vAlign=top>
<H2>Features</H2>
<H3>Properties </H3>All kinds of settings to modify the layout of the
worksheet are provided.
<UL>
<LI>Name of worksheet and file
<LI>Header texts
<LI>Begin row of header, titles (=fieldnames) and data (fieldvalues)
<LI>Width of columns or autofit
<LI>Font of header, titles, summary and data (Alignment, WrapText,
Orientation)
<LI>Backgroundcolor and borders of header, titles, summary and data
<LI>Summaries for numeric or given fields (SUM, MIN, MAX, AVG)
<LI>Create groups with given fields
<LI>A lot of other options to customize the result
<LI>Access to the Excel objects (workbook, worksheet, cells,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -