Questo il codice:
14 /// <summary>
15 /// Create a E-Mail Attach from Stream
16 /// </summary>
17 private static void StreamToAttachment()
18 {
19 //...create the mail message
20 MailMessage _mail = new MailMessage();
21
22 //...set the addresses and content
23 _mail.From = new MailAddress("mailFrom@cbonacci.net");
24 _mail.To.Add("mailFrom@cbonacci.net");
25 _mail.Subject = "Excel: Attachments and Streams";
26 _mail.Body = "... I love C# ...!";
27
28 //... retrieve binary data and save to a stream
29 byte[] _data = _streamBuilder();
30 MemoryStream _stream = new MemoryStream(_data);
31
32 _mail.Attachments.Add(
33 new Attachment(_stream,
34 "cb_example.xls",
35 MediaTypeNames.Text.Plain)
36 );
37
38 //...send the message
39 SmtpClient _smtp = new SmtpClient("127.0.0.1");
40 _smtp.Send(_mail);
41 }
42
43 /// <summary>
44 ///
45 /// </summary>
46 /// <returns></returns>
47 private static byte[] _streamBuilder()
48 {
49 string _xml = _createWorkbookFromdataSet(
50 //...get your data from dataBase
51 GetDataForDB() );
52
53 byte[] _byteData = Encoding.ASCII.GetBytes(_xml);
54 return _byteData;
55 }
56
57 /// <summary>
58 ///
59 /// </summary>
60 /// <param name="sourceData"></param>
61 /// <returns></returns>
62 private static string _createWorkbookFromdataSet(DataSet sourceData)
63 {
64 XmlDataDocument _xmlDataDoc =
65 new XmlDataDocument(sourceData);
66 XslCompiledTransform _xt =
67 new XslCompiledTransform();
68 StreamReader _reader = new
69
70 StreamReader("Excel.xsl");
71 XmlTextReader xRdr = new XmlTextReader(_reader);
72
73 _xt.Load(xRdr, null, null);
74 StringWriter _sw = new StringWriter();
75 _xt.Transform(_xmlDataDoc, null, _sw);
76
77 //...retunr string XML Worksheet.
78 return _sw.ToString();
79 }
... a very simple Excel/xls
1 <xsl:stylesheet version="1.0"
2 xmlns="urn:schemas-microsoft-com:office:spreadsheet"
3 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
4 xmlns:msxsl="urn:schemas-microsoft-com:xslt"
5 xmlns:user="urn:my-scripts"
6 xmlns:o="urn:schemas-microsoft-com:office:office"
7 xmlns:x="urn:schemas-microsoft-com:office:excel"
8 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" >
9
10 <xsl:template match="/">
11 <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
12 xmlns:o="urn:schemas-microsoft-com:office:office"
13 xmlns:x="urn:schemas-microsoft-com:office:excel"
14 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
15 xmlns:html="http://www.w3.org/TR/REC-html40">
16 <xsl:apply-templates/>
17 </Workbook>
18 </xsl:template>
19
20 <xsl:template match="/*">
21 <Worksheet>
22 <xsl:attribute name="ss:Name">
23 <xsl:value-of select="local-name(/*/*)"/>
24 </xsl:attribute>
25 <Table x:FullColumns="1" x:FullRows="1">
26 <Row>
27 <xsl:for-each select="*[position() = 1]/*">
28 <Cell><Data ss:Type="String">
29 <xsl:value-of select="local-name()"/>
30 </Data></Cell>
31 </xsl:for-each>
32 </Row>
33 <xsl:apply-templates/>
34 </Table>
35 </Worksheet>
36 </xsl:template>
37
38 <xsl:template match="/*/*">
39 <Row>
40 <xsl:apply-templates/>
41 </Row>
42 </xsl:template>
43
44 <xsl:template match="/*/*/*">
45 <Cell><Data ss:Type="String">
46 <xsl:value-of select="."/>
47 </Data></Cell>
48 </xsl:template>
Ciao
1 commento:
There are massive prizes to be received properly as|in addition to} amazing features select from|to select from}, to provide your recreation a lift. The experience is interactive with the stay dealer, the place you’ll need to guess which numbers the wheel will land on to climb onto the following stage. We’re all familiar with the wheel of fortune, the place you spin and hope the wheel lands on a prize. This type of recreation by no means loses its charm and enjoyable issue, and it’s potential to play these types of|these sort of|most of these} games right here at Mr Green. We also have a foyer filled with gameshow fashion titles and plenty of thrilling variations on extra conventional games that are be} extremely well-liked if you're looking 카지노사이트 for a less severe stay casino recreation. Live Blackjack is extremely well-liked and you will find many thrilling variances of this straightforward card recreation at Mr Green.
Posta un commento