主页 / user-337817

EfimoffN's questions

Martin Hope
EfimoffN
Asked: 2020-04-17 23:21:16 +0000 UTC
  • 2

我试图弄清楚如何在 Kotlin 中处理日期和时间到目前为止，我发现的所有东西看起来都像拐杖，要加一天，你需要写 4 行

String dt = "2008-01-01";  
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Calendar c = Calendar.getInstance();
c.setTime(sdf.parse(dt));
c.add(Calendar.DATE, 1);  
dt = sdf.format(c.getTime());
kotlin
Martin Hope
EfimoffN
Asked: 2020-06-11 20:02:04 +0000 UTC
  • 0

我正在尝试像这样为 Excel 构建 XML：

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
          xmlns:o="urn:schemas-microsoft-com:office:office" 
          xmlns:x="urn:schemas-microsoft-com:office:excel" 
          xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
          xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>OOO XXX</Author>
  <LastAuthor>Nickolay Efimov</LastAuthor>
  <Created>2018-03-20T06:19:09Z</Created>
 </DocumentProperties>
</Workbook>

我的 C# 代码：

    XElement Workbook = new XElement(xmlns + "Workbook",
                    new XAttribute("xmlns", "urn:schemas-microsoft-com:office:spreadsheet"),
                    new XAttribute(XNamespace.Xmlns + "o", "urn:schemas-microsoft-com:office:office"),
                    new XAttribute(XNamespace.Xmlns + "x", "urn:schemas-microsoft-com:office:excel"),
                    new XAttribute(XNamespace.Xmlns + "ss", "urn:schemas-microsoft-com:office:spreadsheet"),
                    new XAttribute(XNamespace.Xmlns + "html", "http://www.w3.org/TR/REC-html40"),
                    new XElement(xmlnsO + "DocumentProperties",
                        new XAttribute("xmlns", "urn:schemas-microsoft-com:office:office"), 
                        new XElement("Author", "OOO XXX"),
                        new XElement("LastAuthor", "Nickolay Efimov"), 
                        new XElement("Created", "2018-03-20T06:19:09Z")));

输出 XML 如下所示：

<ss:Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" 
             xmlns:o="urn:schemas-microsoft-com:office:office" 
             xmlns:x="urn:schemas-microsoft-com:office:excel" 
             xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" 
             xmlns:html="http://www.w3.org/TR/REC-html40">
  <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
    <Author xmlns="">OOO XXX</Author>
    <LastAuthor xmlns="">Nickolay Efimov</LastAuthor>
    <Created xmlns="">2018-03-20T06:19:09Z</Created>
  </DocumentProperties>
</ss:Workbook>

我不明白为什么ss出现在Workbook中以及xmlns=""来自DocumentProperties子元素中的位置

c#