将.xlsx文件解析为另一种形式 [英] Parsing .xlsx file into another form

问题描述

大家好，



我不知道如何上传问题的示例文件。所以直接在这里粘贴内容。



我有以下.xlsx文件。

Hello Everyone,

I'm not sure how to upload a sample file for a question. So pasting the content directly here.

i have the following .xlsx file.

Application Field Detail: Control Procedures					
System Name: DPE Archer GRC  Version: 6.1.00201.1002					
Tuesday, October 10, 2017					
Application Name:	Control Procedures				
Description:	sss				
Status:	Production				
Application Owner(s):	"CM: Admin
PM: Admin"				
Field Calculation Order:	ssss				
Recalculation Schedule:	0 Days  				
Application Fields					
General:	Field Name:	Procedure ID			
	Alias:	Procedure_ID			
	Field ID:	{426748AB-F600-4930-9CBE-AC176F9924FD}			
	Field Type:	Tracking ID			
	Status:	Active			
	Description:	"This field is automatically populated with a value that 
uniquely identifies the record across all applications within 
the system."			
	Display Control:	Read Only			
	Field Permissions:	Public			
Options:	Search Results:	Yes		Search Default:	Yes
	Key:	No			
Configuration Attributes:	ID Type:	System ID			
	Prefix:				
	Suffix:				
Help Text:	Text:	"This field displays a value that uniquely identifies the record 
across all applications within the system."			
	View Display:	Tooltip			
	Edit Display:	Tooltip			
General:	Field Name:	Last Updated			
	Alias:	Last_Updated			
	Field ID:	{FD766D6A-7EB3-462B-B32B-F81612504336}			
	Field Type:	Last Updated Date			
	Status:	Active			
	Description:	"This field is automatically populated with the date the record 
was last updated."			
	Display Control:	Read Only			
	Field Permissions:	Public			
Options:	Search Results:	Yes		Search Default:	No
	Include Time:	Yes		Include User:	Yes
	Header Display:	Yes			
Help Text:	Text:	This field displays the date the record was last updated.			
	View Display:	Tooltip			
	Edit Display:	Tooltip

我想将其转换为以下格式

I would like to convert that into the following format

Application/Questionnaire	Field Name	Field Alias	Field ID	Status	Level	Field Type	Description	Help Text	Required?	Calculated Field?
Control Procedures	Procedure ID	Procedure_ID	{426748AB-F600-4930-9CBE-AC176F9924FD}			Tracking ID	"This field is automatically populated with a value that 
uniquely identifies the record across all applications within 
the system."	"This field displays a value that uniquely identifies the record 
across all applications within the system."		
Control Procedures	Last Updated	Last_Updated	{FD766D6A-7EB3-462B-B32B-F81612504336}			Last Updated Date	"This field is automatically populated with the date the record 
was last updated."	This field displays the date the record was last updated.		
Control Procedures	Description	Description	{8AAB3C20-FE24-40BE-B5D6-90F32C2B8767}			Text	This field is used to describe the control activity.	Enter a detailed description of the control activity.		No
Control Procedures	Control Placement	Control_Placement	{0BC9C8A6-D992-4A3A-801D-2D10E081C13E}			Values List	"This field indicates whether the control is preventive or 
detective. For definitions, see the field-level help text."	"Select whether the control is preventive or detective 
according to the following definitions:"

我正在努力设计某种逻辑。我可以得到一些帮助吗？



问候，

Swayam



< b>我尝试了什么：



我对逻辑非常困难。所以根本无法启动。

如果我能得到一些指导，我会很棒。

I am struggling to device some sort of logic. Could i get some help?

Regards,
Swayam

What I have tried:

I pretty much struggled with the logic. So could not start at all.
I would be great if i could get some guidance.

推荐答案

我不确定那是什么你发布了，但它看起来不像Excel文件的内容。但是，请参阅使用MS Excel（xls / xlsx）使用MDAC和Oledb [ ^ ]以提取工作簿的所有内容的简单方法。

I am not sure what that is you have posted, but it does not look anything like the contents of an Excel file. However, see Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] for a simple way to extract all the content of a workbook.

这篇关于将.xlsx文件解析为另一种形式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！