Lightnews — Scholar-powered news

狸

@tanuki-phoenix.bsky.social

13 followers 94 following 80 posts

アニメ好き経理マン。 Xと並行運用中
Power Queryは仕事のお供。
I love #CSS and #XML .

Posts Replies Media Videos

狸

@tanuki-phoenix.bsky.social

The aspect-ratio of this image is strange in Firefox(android).
www.kamaboko.com/sakanano/col...

March 22, 2025 at 2:34 AM

狸

@tanuki-phoenix.bsky.social

I got it. It worked.

January 27, 2025 at 3:41 PM

狸

@tanuki-phoenix.bsky.social

複数のXMLをマッピングしているブックのSave AsでXML（not XMLSS）を選択した場合、一体どう保存されるのだろうと思ったが、何のことはない、どっちか選べと言われた。
やはり、複雑なXMLを出力したいのであれば、そういうスキーマを用意しなければならない。
#Excel #XML

January 20, 2025 at 4:04 PM

狸

@tanuki-phoenix.bsky.social

I've seen "a" element has 'href= "#"'.
ButI in the example below, "a" element does not even have a href attribute.

January 13, 2025 at 12:59 PM

狸

@tanuki-phoenix.bsky.social

To add a reference to a css file to exporting data, I had to use VBA.
#Excel #XML

$Public Sub test3() Dim temp As String 'add XML contents to a variable ActiveWorkbook.XmlMaps("r1").ExportXml temp Dim regex As Object Set regex = CreateObject("VBScript.RegExp") regex.Pattern = "(<\?.+\?>)" Dim referenceToCssTxt As String referenceToCssTxt = "<?xml-stylesheet type=""text/css"" href=""forDummy.css"" ?>" 'in case of replacing all occurences 'regex.Global = True temp = regex.Replace(temp, "$1" & vbCrLf & referenceToCssTxt & vbCrLf) 'write the result to xml file Dim adodbStream As Object Set adodbStream = CreateObject("ADODB.Stream") adodbStream.Type = 2 'Specify stream type - text/string data. adodbStream.Charset = "utf-8" adodbStream.Open adodbStream.WriteText temp adodbStream.SaveToFile "test.xml", 2 'Save binary data To disk adodbStream.Close Set adodbStream = Nothing End Sub$

January 12, 2025 at 3:57 PM

狸

@tanuki-phoenix.bsky.social

1個のテーブルでロードしてしまうと無理だけども。

January 12, 2025 at 8:22 AM

狸

@tanuki-phoenix.bsky.social

こんな感じで分ければ、出力できますな。
#Excel #XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<branch1>
<item attr1="a" attr2="b"/>
<item attr1="a" attr2="C"/>
<item attr1="a" attr2="C"/>
<item attr1="a" attr2="b"/>
</branch1>
<branch2>
<person>
<name>どらえもん</name>
<birthday>1974-10-01</birthday>
<last_update>2025-01-10</last_update>
</person>
<person>
<name>どらえもん2</name>
<birthday>1974-11-01</birthday>
<last_update>2025-01-03</last_update>
</person>
<person>
<name>どらみ</name>
<birthday>1983-01-01</birthday>
<last_update>2024-12-28</last_update>
</person>
</branch2>
</root>

January 12, 2025 at 8:22 AM

狸

@tanuki-phoenix.bsky.social

XSLT to extract texts from Youtube transcript.
I used a line feed as delimiter.

†The code is in the alt text in the image below.
#XML

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<content>
<xsl:apply-templates select="//yt-formatted-string[contains(@class,'segment-text')]"/>
</content>
</xsl:template>
<xsl:template match="yt-formatted-string">
<xsl:value-of select="."/>
<xsl:text>
</xsl:text>
</xsl:template>
</xsl:stylesheet>

January 4, 2025 at 5:23 AM

狸

@tanuki-phoenix.bsky.social

I struggled with transposing a HTML table.
"Display:grid" should be applied to a tbody element, not a table.
It seems that a tbody element is automatically inserted into a table element.
#CSS