Click here to Skip to main content
15,897,095 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:"



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.
Posted
Updated 3-Jan-18 22:50pm
v2
Comments
Maciej Los 3-Jan-18 15:18pm    
Are you sure it is xlsx file? It might be csv file.
swayamrath 3-Jan-18 16:38pm    
It's xlsx. :)

1 solution

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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900