Blue Eye Logo

Blue Eye Macro

Automation is freedom
It is currently Sun Apr 23, 2017 11:49 am

All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Working with excel files tip
Thanked: 2 time(s)  Unread post Posted: Fri Feb 14, 2014 8:18 pm 
Silver Contributor
Silver Contributor



Joined: Wed Jan 29, 2014 7:47 pm
Posts: 240
Location: United States
Been thanked: 49 time(s)
Has thanked: 2 time(s)
Contribution Points: 802
For those of you wanting to deal with excel files, here's a nice feature you may or may not know about. A typical excel file when saved and opened in a text editor (per say Notepad). Will be in either in gibberish or XML usually ie:

Code:
PK     ! bîha     [Content_Types].xml ¢(     þ¸ú   ÿÿ PK-      ! bîha                     [Content_Types].xmlPK-      ! µU0#õ   L               š  _rels/.relsPK-      ! >”—ô   º               À  xl/_rels/workbook.xml.relsPK-      ! ¦zÎ5E                 ô  xl/workbook.xmlPK-      ! 9Û…·ß   À               f
  xl/sharedStrings.xmlPK-      ! ûb¥m”  §               w   xl/theme/theme1.xmlPK-      ! ÐÌH”H  ì 
             <  xl/styles.xmlPK-      ! fÛünº  ™               ¯  xl/worksheets/sheet1.xmlPK-      ! }á~H  c               Ÿ  docProps/core.xmlPK-      ! <0þ  þ                 docProps/app.xmlPK   
 
 €  Õ   


or

Code:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<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">
  <Created>2011-11-11T21:53:05Z</Created>
  <LastSaved>2014-02-14T20:09:14Z</LastSaved>
  <Version>14.00</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>8070</WindowHeight>
  <WindowWidth>15180</WindowWidth>
  <WindowTopX>120</WindowTopX>
  <WindowTopY>120</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="8" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="15">
   <Column ss:AutoFitWidth="0" ss:Width="88.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="105.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="218.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="106.5"/>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE 2LT/MODE 2LT RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE 2LT/MODE RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE ECO</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE LS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE LT/MODE LT RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE LT/MODE RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE LTZ/MODE LTZ RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">2011</Data></Cell>
    <Cell><Data ss:Type="String">CHEV</Data></Cell>
    <Cell><Data ss:Type="String">MODE LTZ/MODE RS</Data></Cell>
    <Cell><Data ss:Type="Number">4</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.3"/>
    <Footer x:Margin="0.3"/>
    <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
   </PageSetup>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>368</ActiveRow>
     <RangeSelection>R369</RangeSelection>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>




As you can see from the above examples, this is probably not easy to work with in BEM. Although the XML format may is manageable, but painfully so. But if you save your file in a CSV format:

Code:
2011,CHEV,MODE 2LT/MODE 2LT RS,4
2011,CHEV,MODE 2LT/MODE RS,4
2011,CHEV,MODE ECO,4
2011,CHEV,MODE LS,4
2011,CHEV,MODE LT/MODE LT RS,4
2011,CHEV,MODE LT/MODE RS,4
2011,CHEV,MODE LTZ/MODE LTZ RS,4
2011,CHEV,MODE LTZ/MODE RS,4



It's much easier to work with. A lot of times using excel to manipulate data is quick and efficient but then if we want to mess with it in BEM or something similar for macros, it's a different story, so this may come in handy.

_________________
- A good programmer is not someone who knows every language but someone who can think logically.


Top
 Profile  
Reply with quote  
 Post subject: Re: Working with excel files tip
Thanked: 0 time(s)  Unread post Posted: Fri Feb 14, 2014 9:23 pm 
Moderator
Moderator



Joined: Tue Feb 05, 2013 5:45 am
Posts: 276
Been thanked: 45 time(s)
Has thanked: 11 time(s)
Contribution Points: 5355
That's great, I never had any situation where I had to deal with a excel but I have seen so many people asking about excel in the forum, this will come very handy.

_________________
Heavy Duty Mod, always watching with both eyes open 8-)

Please --- Please --- Please DO NOT reply to spam thread/post.
I will give you CP if you report spam thread/post instead of replying to it. :)

Click Here>> Let's make BEM forum out of spammers

-------------------------
Check out my Bots
-------------------------

Auto login to the game


Top
 Profile  
Reply with quote  
 Post subject: Re: Working with excel files tip
Thanked: 0 time(s)  Unread post Posted: Mon Sep 14, 2015 3:50 am 
New User
New User



Joined: Mon Sep 14, 2015 3:45 am
Posts: 1
Been thanked: 0 time(s)
Has thanked: 0 time(s)
Contribution Points: 10
I feel that here, yes it's real chill.

_________________
sbobet


Top
 Profile  
Reply with quote  
 Post subject: Re: Working with excel files tip
Thanked: 0 time(s)  Unread post Posted: Wed Dec 23, 2015 6:45 am 
New User
New User



Joined: Wed Dec 23, 2015 4:03 am
Posts: 1
Been thanked: 0 time(s)
Has thanked: 0 time(s)
Contribution Points: 10
I like to talk, to exchange experiences in this forum. It is very good to very good..

_________________
สมัครบาคาร่า


Top
 Profile  
Reply with quote  
 Post subject: Re: Working with excel files tip
Thanked: 0 time(s)  Unread post Posted: Sat Dec 03, 2016 7:08 pm 
Contributor
Contributor



Joined: Wed Nov 30, 2016 9:26 pm
Posts: 60
Location: Indonesia
Been thanked: 2 time(s)
Has thanked: 3 time(s)
Contribution Points: 20
i dont know how to BEM work in program like excel and etc.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC


You cannot post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group