Blue Eye Logo

Blue Eye Macro

Automation is freedom
It is currently Mon Dec 10, 2018 11:01 am

All times are UTC




Post a reply
Username:
Subject:
Message body:
Enter your message here, it may contain no more than 60000 characters. 

Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
Font size:
Font colour
Options:
BBCode is ON
[img] is OFF
[flash] is OFF
[url] is ON
Smilies are ON
Disable BBCode
Disable smilies
Do not automatically parse URLs
Please click and drag the 2 correct statements to the right hand side.
Please click and drag the 2 correct statements to the right hand side.
Please select the options below to the correct list to avoid automated registrations.
Statements
2 correct statements
Fish can swim
Elephants can fly
Dogs have 4 legs
Chickens can talk
   

Topic review - Working with excel files tip
Author Message
  Post subject:  Re: Working with excel files tip  Reply with quote
i dont know how to BEM work in program like excel and etc.
Post Posted: Sat Dec 03, 2016 7:08 pm
  Post subject:  Re: Working with excel files tip  Reply with quote
I like to talk, to exchange experiences in this forum. It is very good to very good..
Post Posted: Wed Dec 23, 2015 6:45 am
  Post subject:  Re: Working with excel files tip  Reply with quote
I feel that here, yes it's real chill.
Post Posted: Mon Sep 14, 2015 3:50 am
  Post subject:  Re: Working with excel files tip  Reply with quote
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.
Post Posted: Fri Feb 14, 2014 9:23 pm
  Post subject:  Working with excel files tip  Reply with quote
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.
Post Posted: Fri Feb 14, 2014 8:18 pm

All times are UTC


Jump to:  


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