天道酬勤,学无止境

xlm

How to get a specifc information for an XML file

问题 我有一个很大的XML文件,下面是其中的摘录: ... <LexicalEntry id="Ait~ifAq_1"> <Lemma partOfSpeech="n" writtenForm="اِتِّفاق"/> <Sense id="Ait~ifAq_1_tawaAfuq_n1AR" synset="tawaAfuq_n1AR"/> <WordForm formType="root" writtenForm="وفق"/> </LexicalEntry> <LexicalEntry id="tawaA&um__1"> <Lemma partOfSpeech="n" writtenForm="تَوَاؤُم"/> <Sense id="tawaA&um__1_AinosijaAm_n1AR" synset="AinosijaAm_n1AR"/> <WordForm formType="root" writtenForm="وأم"/> </LexicalEntry> <LexicalEntry id="tanaAgum_2"> <Lemma partOfSpeech="n" writtenForm="تناغُم"/> <Sense id="tanaAgum_2_AinosijaAm_n1AR" synset="AinosijaAm_n1AR"/> <WordForm

2022-05-15 18:19:05    分类:技术分享    java   parsing   xlm

How to get a specifc information for an XML file

I have a large XML file and below is an extract from it: ... <LexicalEntry id="Ait~ifAq_1"> <Lemma partOfSpeech="n" writtenForm="اِتِّفاق"/> <Sense id="Ait~ifAq_1_tawaAfuq_n1AR" synset="tawaAfuq_n1AR"/> <WordForm formType="root" writtenForm="وفق"/> </LexicalEntry> <LexicalEntry id="tawaA&um__1"> <Lemma partOfSpeech="n" writtenForm="تَوَاؤُم"/> <Sense id="tawaA&um__1_AinosijaAm_n1AR" synset="AinosijaAm_n1AR"/> <WordForm formType="root" writtenForm="وأم"/> </LexicalEntry> <LexicalEntry id="tanaAgum_2"> <Lemma partOfSpeech="n" writtenForm="تناغُم"/> <Sense id="tanaAgum_2_AinosijaAm_n1AR" synset=

2022-04-30 22:08:48    分类:问答    java   parsing   xlm

Set the color of one cell based on the color of another cell

What I would like to have is: IF A1 in Sheet 2 is blue Then A1 in Sheet 1 changes to blue I know I can get the color of A1 in Sheet 2 by using: =GET.CELL(63,Sheet2!A1) (Excel: Can I create a Conditional Formula based on the Color of a Cell?) But I can't figure out what I should do in the next step. Update on 12.01.2015 At the beginning I thought a function would work, but as I considered my file, VBA may be needed. It is about the output of a correlation analyse from SPSS, there are three columns: correlation coefficient, p-value and sample size. I need to check the coefficient and p-value at

2022-03-08 02:42:23    分类:问答    excel   vba   format   excel-4.0   xlm

Importing ODK XML file to MS Access using XLST transformation

I'm trying to import a submission.xml file generated from an ODK survey into Access. I'm using the 'XML import' function in MS Access and need to transform the data so that the each data set of a node that will be imported to a table will contain the ID of the survey. I have a XML with the survey data that looks like this: <SoLa_Tu_Insp_2016-03-13 id="SOLA-160313" instanceID="uuid:63c27738-df02-4298-9090-7ab96d4e1ab2" submissionDate="2016-04-08T02:11:47.600Z" isComplete="true" markedAsCompleteDate="2016-04-08T02:13:12.322Z" xmlns="http://opendatakit.org/submissions"> <start>2016-04-08T23:47:50

2022-02-14 19:11:56    分类:问答    ms-access   xslt   import   odk   xlm

根据可变的用户定义路径从关闭的工作簿复制数据(Copy data from closed workbook based on variable user defined path)

问题 我已经用尽了我的搜索能力来寻找解决方案。 这是我想做的事情的概述: 用户打开启用宏的 Excel 文件立即提示用户输入或选择所需工作簿的文件路径。 他们需要选择两个文件,文件名可能不一致输入文件位置后,第一个文件选择的第一个工作表将被复制到启用宏的工作簿的第一个工作表,第二个文件选择的第一个工作表将复制到启用宏的工作簿的第二个工作表. 我遇到过一些对 ADO 的引用,但我真的不熟悉它。 编辑:我找到了从关闭的文件中导入数据的代码。 我需要调整范围以返回可变结果。 Private Function GetValue(path, file, sheet, ref) path = "C:\Users\crathbun\Desktop" file = "test.xlsx" sheet = "Sheet1" ref = "A1:R30" ' Retrieves a value from a closed workbook Dim arg As String ' Make sure the file exists If Right(path, 1) <> "\" Then path = path & "\" If Dir(path & file) = "" Then GetValue = "File Not Found" Exit Function End If ' Create

2021-12-08 14:47:46    分类:技术分享    vba   excel   excel-2007   xlm

XLT 不解析 Saxon 中的数据(XLT does not parse the data in Saxon)

问题 关于我的目标的简短说明。 我想用 Saxon 解析一个 xlm 文件,最后得到一个带有代码的文本文件。 像这样:function1(){ a+a;} 功能2(){ b+b;} 函数3(){ c+c;} 我的想法是使用<apply>模板标签创建这样的代码,以便对于每个面向<tr>标签的文本文件,将使用<td>标签中的必要方法来填充文本文件。 例如, <tr>每个第一个孩子都是一个 function1()。 以下是错误: Warning XTDE0540: Ambiguous rule match for /html/body[1]/table[1] Matches both "document-node()/element(Q{http://www.w3.org/1999/xhtml}html)/element(Q{http://www.w3.org/1999/xhtml}body)/element(Q{http://www.w3.org/1999/xhtml}table)" on line 71 of file:/C:/Users/fleonov/Desktop/test_for_thomas/Var_05_02/transfer_html.xsl and "document-node()/element(Q{http://www.w3.org/1999/xhtml}html

2021-12-05 09:48:08    分类:技术分享    xslt   saxon   xlm

Copy data from closed workbook based on variable user defined path

I have exhausted my search capabilities looking for a solution to this. Here is an outline of what I would like to do: User opens macro-enabled Excel file Immediate prompt displays for user to enter or select file path of desired workbooks. They will need to select two files, and the file names may not be consistent After entering the file locations, the first worksheet from the first file selection will be copied to the first worksheet of the macro-enabled workbook, and the first worksheet of the second file selection will be copied to the second worksheet of the macro-enabled workbook. I've

2021-11-22 12:58:54    分类:问答    vba   excel   excel-2007   xlm

XLT does not parse the data in Saxon

Short about my aim. I want to parse a xlm file with Saxon and at the end get a text file with code. Something like this: function1(){ a+a;} function2(){ b+b;} function3(){ c+c;} My Idea is to create Such code using <apply> template tag so that for each facing a <tr> tag, a text file would be fullfiled with necessary methods that are in <td> tags. For example for each first child of <tr> is a function1(). Here are the errors: Warning XTDE0540: Ambiguous rule match for /html/body[1]/table[1] Matches both "document-node()/element(Q{http://www.w3.org/1999/xhtml}html)/element(Q{http://www.w3.org

2021-11-13 04:14:06    分类:问答    xslt   saxon   xlm