MIME生成多sheet excel 有关问题
MIME生成多sheet excel 问题
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
public class NewText {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
FileOutputStream fileOutput = new FileOutputStream("C:\\java\\eclipse3.6.2\\c.xls");
PrintWriter fileWrite = new PrintWriter(new OutputStreamWriter(fileOutput,"utf-8"));
BufferedWriter file = new BufferedWriter(fileWrite);
file.write("MIME-Version: 1.0\n");
file.write("X-Document-Type: Workbook\n");
file.write("Content-Type: multipart/related; boundary=\"----LAURE----\"\n");
file.write("\n");
file.write("------LAURE----\n");
file.write("Content-Location: file:///C:/0E8D990CD/laure_excel.xml\n");
file.write("Content-Transfer-Encoding: quoted-printable\n");
file.write("Content-Type: text/html; charset=\"UTF-8\"\n");
file.write("\n");
file.write("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\n");
file.write("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\"\n");
file.write("xmlns=3D\"http://www.w3.org/TR/REC-html40\">\n");
file.write("\n");
file.write("<head>\n");
file.write("<xml>\n");
file.write(" <o:DocumentProperties>\n");
file.write(" <o:Author>laure</o:Author>\n");
file.write(" <o:LastAuthor>laure</o:LastAuthor>\n");
file.write(" <o:Created>2005-07-10T17:02:17Z</o:Created>\n");
file.write(" <o:LastSaved>2005-07-10T17:06:05Z</o:LastSaved>\n");
file.write(" <o:Company>laure-soft</o:Company>\n");
file.write(" <o:Version>1.0</o:Version>\n");
file.write(" </o:DocumentProperties>\n");
file.write("</xml>\n");
file.write("<xml>\n");
file.write(" <x:ExcelWorkbook>\n");
file.write(" <x:ExcelWorksheets>\n");
file.write(" <x:ExcelWorksheet>\n");
file.write(" <x:Name>cnblogs</x:Name>\n");
file.write(" <x:WorksheetSource HRef=3D\"cid:sheet001\"/>\n");
file.write(" </x:ExcelWorksheet>\n");
file.write(" <x:ExcelWorksheet>\n");
file.write(" <x:Name>birdshome</x:Name>\n");
file.write(" <x:WorksheetSource HRef=3D\"cid:sheet002\"/>\n");
file.write(" </x:ExcelWorksheet>\n");
file.write(" <x:ExcelWorksheet>\n");
file.write(" <x:Name>mime</x:Name>\n");
file.write(" <x:WorksheetSource HRef=3D\"cid:sheet003\"/>\n");
file.write(" </x:ExcelWorksheet>\n");
file.write(" <x:ExcelWorksheet>\n");
file.write(" <x:Name>excel</x:Name>\n");
file.write(" <x:WorksheetSource HRef=3D\"cid:sheet004\"/>\n");
file.write(" </x:ExcelWorksheet>\n");
file.write(" </x:ExcelWorksheets>\n");
file.write(" </x:ExcelWorkbook>\n");
file.write("</xml>\n");
file.write("</head>\n");
file.write("</html>\n");
file.write("\n");
file.write("------LAURE----\n");
file.write("Content-ID: sheet001\n");
file.write("Content-Transfer-Encoding: quoted-printable\n");
file.write("Content-Type: text/html; charset=\"UTF-8\"\n");
file.write("\n");
file.write("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\n");
file.write("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\"\n");
file.write("xmlns=3D\"http://www.w3.org/TR/REC-html40\">\n");
file.write("\n");
file.write("<head>\n");
file.write("<xml>\n");
file.write(" <x:WorksheetOptions>\n");
file.write(" <x:ProtectContents>False</x:ProtectContents>\n");
file.write(" <x:ProtectObjects>False</x:ProtectObjects>\n");
file.write(" <x:ProtectScenarios>False</x:ProtectScenarios>\n");
file.write(" </x:WorksheetOptions>\n");
file.write("</xml>\n");
file.write("</head>\n");
file.write("<body>\n");
file.write("<table>\n");
file.write(" <tr>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" </tr>\n");
file.write(" <tr>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" </tr>\n");
file.write(" <tr>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" <td>cnblogs</td>\n");
file.write(" </tr>\n");
file.write(" </table>\n");
file.write("</body>\n");
file.write("</html>\n");
file.write("\n");
file.write("------LAURE----\n");
file.write("Content-ID: sheet002\n");
file.write("Content-Transfer-Encoding: quoted-printable\n");
file.write("Content-Type: text/html; charset=\"UTF-8\"\n");
file.write("\n");
file.write("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\n");
file.write("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\"\n");
file.write("xmlns=3D\"http://www.w3.org/TR/REC-html40\">\n");
file.write("\n");
file.write("<head>\n");
file.write("<xml>\n");
file.write(" <x:WorksheetOptions>\n");
file.write(" <x:ProtectContents>False</x:ProtectContents>\n");
file.write(" <x:ProtectObjects>False</x:ProtectObjects>\n");
file.write(" <x:ProtectScenarios>False</x:ProtectScenarios>\n");
file.write(" </x:WorksheetOptions>\n");
file.write("</xml>\n");
file.write("</head>\n");
file.write("<body link=3Dblue vlink=3Dpurple>\n");
file.write("<table x:str border=3D0 cellpadding=3D0 cellspacing=3D0 width=3D360 style=\n");
file.write("=3D'border-collapse:\n");
file.write(" collapse;table-layout:fixed;width:270pt'>\n");
file.write(" <col width=3D72 span=3D5 style=3D'width:54pt'>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 width=3D72 style=3D'height:14.25pt;width:54pt'>birdshome<=\n");
file.write("/td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>birdshome</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>birdshome</td>\n");
file.write(" <td colspan=3D2 width=3D144 style=3D'mso-ignore:colspan;width:108pt'>bird=\n");
file.write("shome</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>birdshome</td>\n");
file.write(" <td>birdshome</td>\n");
file.write(" <td>birdshome</td>\n");
file.write(" <td colspan=3D2 style=3D'mso-ignore:colspan'>birdshome</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>birdshome</td>\n");
file.write(" <td>birdshome</td>\n");
file.write(" <td>birdshome</td>\n");
file.write(" <td colspan=3D2 style=3D'mso-ignore:colspan'>birdshome</td>\n");
file.write(" </tr>\n");
file.write("</table>\n");
file.write("</body>\n");
file.write("</html>\n");
file.write("\n");
file.write("------LAURE----\n");
file.write("Content-ID: sheet003\n");
file.write("Content-Transfer-Encoding: quoted-printable\n");
file.write("Content-Type: text/html; charset=\"UTF-8\"\n");
file.write("\n");
file.write("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\n");
file.write("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\"\n");
file.write("xmlns=3D\"http://www.w3.org/TR/REC-html40\">\n");
file.write("\n");
file.write("<head>\n");
file.write("<xml>\n");
file.write(" <x:WorksheetOptions>\n");
file.write(" <x:ProtectContents>False</x:ProtectContents>\n");
file.write(" <x:ProtectObjects>False</x:ProtectObjects>\n");
file.write(" <x:ProtectScenarios>False</x:ProtectScenarios>\n");
file.write(" </x:WorksheetOptions>\n");
file.write("</xml>\n");
file.write("</head>\n");
file.write("<body link=3Dblue vlink=3Dpurple>\n");
file.write("<table x:str border=3D0 cellpadding=3D0 cellspacing=3D0 width=3D288 style=\n");
file.write("=3D'border-collapse:\n");
file.write(" collapse;table-layout:fixed;width:216pt'>\n");
file.write(" <col width=3D72 span=3D4 style=3D'width:54pt'>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 width=3D72 style=3D'height:14.25pt;width:54pt'>mime</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>mime</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>mime</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>mime</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" <td>mime</td>\n");
file.write(" </tr>\n");
file.write(" </table>\n");
file.write("</body>\n");
file.write("</html>\n");
file.write("\n");
file.write("------LAURE----\n");
file.write("Content-ID: sheet004\n");
file.write("Content-Transfer-Encoding: quoted-printable\n");
file.write("Content-Type: text/html; charset=\"UTF-8\";\n");
file.write("\n");
file.write("<html xmlns:o=3D\"urn:schemas-microsoft-com:office:office\"\n");
file.write("xmlns:x=3D\"urn:schemas-microsoft-com:office:excel\"\n");
file.write("xmlns=3D\"http://www.w3.org/TR/REC-html40\">\n");
file.write("\n");
file.write("<head>\n");
file.write("<xml>\n");
file.write(" <x:WorksheetOptions>\n");
file.write(" <x:ProtectContents>False</x:ProtectContents>\n");
file.write(" <x:ProtectObjects>False</x:ProtectObjects>\n");
file.write(" <x:ProtectScenarios>False</x:ProtectScenarios>\n");
file.write(" </x:WorksheetOptions>\n");
file.write("</xml>\n");
file.write("</head>\n");
file.write("<body link=3Dblue vlink=3Dpurple>\n");
file.write("<table x:str border=3D0 cellpadding=3D0 cellspacing=3D0 width=3D288 style=\n");
file.write("=3D'border-collapse:\n");
file.write(" collapse;table-layout:fixed;width:216pt'>\n");
file.write(" <col width=3D72 span=3D4 style=3D'width:54pt'>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 width=3D72 style=3D'height:14.25pt;width:54pt'>excel</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>excel</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>excel</td>\n");
file.write(" <td width=3D72 style=3D'width:54pt'>excel</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>excel</td>\n");
file.write(" <td>excel</td>\n");
file.write(" <td>excel</td>\n");
file.write(" <td>excel</td>\n");
file.write(" </tr>\n");
file.write(" <tr height=3D19 style=3D'height:14.25pt'>\n");
file.write(" <td height=3D19 style=3D'height:14.25pt'>excel</td>\n");
file.write(" <td>A</td>\n");
file.write(" <td>A</td>\n");
file.write(" <td>excel</td>\n");
file.write(" </tr>\n");
file.write(" <tr>\n");
file.write(" </tr>\n");
file.write("</table>\n");
file.write("</body>\n");
file.write("</html>\n");
file.write("\n");
file.write("\n");
file.write("------LAURE------\n");
file.write("\n");
file.close();
}
}