The [Address][1] property of a cell can get this for you:

    MsgBox Cells(1, 1).Address(RowAbsolute:=False, ColumnAbsolute:=False)


returns `A1`. 

The other way around can be done with the `Row` and `Column` property of `Range`:

    MsgBox Range(&quot;A1&quot;).Row &amp; &quot;, &quot; &amp; Range(&quot;A1&quot;).Column

returns `1,1`.

  [1]: http://msdn.microsoft.com/en-us/library/aa174749%28v=office.11%29.aspx

The output from ScalaTest is colored to distinguish different states, but these end up as control codes and 

    [34m Annoying garbage 

Is there any way to convince the Eclipse console to either respect or ignore these sequences, or to plug in a view that will?

An Eclipse console view that respects ANSI color codes?

Is it possible for me to download an image from website and save it permanently inside my app? I really have no idea, but it would make a nice feature for my app.


iOS download and save image inside app

I am working on an worksheet generator in Excel 2007. I have a certain layout I have to follow and I often have to format cells based on input. Since the generator is dynamic I have to calculate all kinds of ranges, merge cells, etc.

How can I convert values like this?

`Cells(1,1)` into `A1` and vice versa

Convert cells(1,1) into &quot;A1&quot; and vice versa

I am working on an worksheet generator in Excel 2007. I have a certain layout I have to follow and I often have to format cells based on input. Since the generator is dynamic I have to calculate all kinds of ranges, merge cells, etc.
How can I convert values like this?
<code>Cells(1,1)</code> into <code>A1</code> and vice versa

I have two cells in Excel. one has a string and the other one has a date. in the third cell I want to put the date and the string together.  For example:

    A1 = &quot;This &quot;
    A2 = &quot;03/03/1982&quot;

I want A3 to be:

    This 03/03/1982


when I try to put this in the A3 formula: `= A1 &amp; A2` it returns some funny numerical value for the date and does not give me the literal date. 


Concatenating date with a string in Excel

Can Excel interpret the URLs in my CSV as hyperlinks? If so, how?

Can Excel interpret the URLs in my CSV as hyperlinks?

We have a web app that exports CSV files containing foreign characters with UTF-8, no BOM. Both Windows and Mac users get garbage characters in Excel. I tried converting to UTF-8 with BOM; Excel/Win is fine with it, Excel/Mac shows gibberish. I&#39;m using Excel 2003/Win, Excel 2011/Mac.
Here&#39;s all the encodings I tried:

    
    Encoding  BOM      Win                            Mac
    --------  ---      ----------------------------   ------------
    utf-8     --       scrambled                      scrambled
    utf-8     BOM      WORKS                          scrambled
    utf-16    --       file not recognized            file not recognized
    utf-16    BOM      file not recognized            Chinese gibberish
    utf-16LE  --       file not recognized            file not recognized
    utf-16LE  BOM      characters OK,                 same as Win
                       row data all in first field

The best one is UTF-16LE with BOM, but the CSV is not recognized as such. The field separator is comma, but semicolon doesn&#39;t change things.

**Is there any encoding that works in both worlds?**

Which encoding opens CSV files correctly with Excel on both Mac and Windows?

I have the same issue as in https://stackoverflow.com/questions/5773683/excel-vba-parsed-json-object-loop but cannot find any solution. My JSON has nested objects so suggested solution like VBJSON and vba-json do not work for me. I also fixed one of them to work properly but the result was a call stack overflow because of to many recursion of the doProcess function.

The best solution appears to be the jsonDecode function seen in the original post. It is very fast and highly effective; my object structure is all there in a generic VBA Object of type JScriptTypeInfo.

The issue at this point is that I cannot determine what will be the structure of the objects, therefore, I do not know beforehand the keys that will reside in each generic objects. I need to loop through the generic VBA Object to acquire the keys/properties. 

If my parsing javascript function could trigger a VBA function or sub, that would be excellent. 

Parsing JSON in Excel VBA

I&#39;m trying to get data from an Excel file on a button click event. My connection string is:

     string connString = &quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;&quot;;

When I click on the button, I got the following error:

&gt; The &#39;Microsoft.ACE.OLEDB.12.0&#39; provider is not registered on the local machine.

I have no clue how to fix this. My operating system is Windows 7.

&#39;Microsoft.ACE.OLEDB.12.0&#39; provider is not registered on the local machine

    Dim wkbkdestination As Workbook
    Dim destsheet As Worksheet
    
    For Each ThisWorkSheet In wkbkorigin.Worksheets 
        &#39;this throws subscript out of range if there is not a sheet in the destination 
        &#39;workbook that has the same name as the current sheet in the origin workbook.
        Set destsheet = wkbkdestination.Worksheets(ThisWorkSheet.Name) 
    Next


Basically I loop through all sheets in the origin workbook then set `destsheet` in the destination workbook to the sheet with the same name as the currently iterated one in the origin workbook.

How can I test if that sheet exists? Something like:

    If wkbkdestination.Worksheets(ThisWorkSheet.Name) Then 

Test or check if sheet exists

    Function Foo(thiscell As Range) As Boolean
      Foo = thiscell.hasFormula And (InStr(1, UCase(Split(thiscell.formula, Chr(40))(0)), &quot;bar&quot;) &gt; 0)
    End Function

This function exists to test for the presence of a certain substring (bar, in this case) before the (.

The case I&#39;m having trouble with is when the cell passed into the function is empty, the thisCell.hasFormula is false, but the statement after the and is still being evaluated.  This gives me a subscript out of range error in runtime.

Does VBA actually continue evaluating the second argument to the And, even when the first was false?

Does the VBA &quot;And&quot; operator evaluate the second argument when the first is false?

I have an excel file with one order on each row, and I want each order to have a unique identifier, so there will be a Unique ID column. Every time I fill a row, I want Excel to automatically populate the Unique ID column for me. I did some research and was pointed in the direction of GUIDs. I found the following code: 

    Function GenGuid() As String
    Dim TypeLib As Object
    Dim Guid As String
    Set TypeLib = CreateObject(&quot;Scriptlet.TypeLib&quot;)
    Guid = TypeLib.Guid
    &#39; format is {24DD18D4-C902-497F-A64B-28B2FA741661}
    Guid = Replace(Guid, &quot;{&quot;, &quot;&quot;)
    Guid = Replace(Guid, &quot;}&quot;, &quot;&quot;)
    Guid = Replace(Guid, &quot;-&quot;, &quot;&quot;)
    GenGuid = Guid
    End Function

but I am not sure how I can implement it. Any help would be greatly appreciated. Thank you in advance.



How can I generate GUIDs in Excel?

I have an array prLst that is a list of integers. The integers are not sorted, because their position in the array represents a particular column on a spreadsheet.  I want to know how I find a particular integer in the array, and return its index.  

There does not seem to be any resource on showing me how without turning the array into a range on the worksheet. This seems a bit complicated.  Is this just not possible with VBA?

Return Index of an Element in an Array Excel VBA

Is it possible to merge cells in Org-mode tables?

Examples of horizontal merging would be something like that:

    | Header | Merged header |
    |--------+-------+-------|
    | Text1  | Text2 | Text3 |
    | Text4  | Text5 | Text6 |

Example of vertical merging:

    | Header1 | Header2 | Header3 |
    |---------+---------+---------|
    | Merged  | Text1   | Text2   |
    | text    |---------+---------|
    | here    | Text3   | Text4   |

If that is somehow possible in org-mode? If not, what is the most idiomatic way to simulate merged cells?

Merge cells in org-mode tables

I have created a Pandas DataFrame

    df = DataFrame(index=[&#39;A&#39;,&#39;B&#39;,&#39;C&#39;], columns=[&#39;x&#39;,&#39;y&#39;])

and have got this
&lt;pre&gt;
    x    y
A  NaN  NaN
B  NaN  NaN
C  NaN  NaN
&lt;/pre&gt;

Now, I would like to assign a value to particular cell, for example to row `C` and column `x`.
I would expect to get this result:
&lt;pre&gt;
    x    y
A  NaN  NaN
B  NaN  NaN
C  10  NaN
&lt;/pre&gt;

with this code:

    df.xs(&#39;C&#39;)[&#39;x&#39;] = 10

However, the contents of `df` has not changed. The dataframe contains yet again only `NaN`s. 

Any suggestions?

Set value for particular cell in pandas DataFrame using index

Could anyone explain how to change a single cell in a `data.frame` to something else.
Basically I just want to rename that one cell, not all cells which matches it.
I can&#180;t use the `edit()` command because it will screw up my script since im using the `data.frame` on several occasions.

Thanks in advance

How do I change a single value in a data.frame?

I am having real trouble with this, since the cell.value function returns the formula used for the cell, and I need to extract the result Excel provides after operating.

Thank you.

________________________________________

Ok, I think I ahve found a way around it; apparently to access cell.internal value you have to use the iter_rows() in your worksheet previously, which is a list of &quot;RawCell&quot;.

    for row in ws.iter_rows():

        for cell in row:

            print cell.internal_value

How to access the real value of a cell using the openpyxl module for python

I have a grouped UITableview which is created programatically. Also I have a cell with xib file populated in tableview programmatically as well. So far so good. But I want to only remove outer separator line. I used below code but this time removed all separator line. 

&gt; self.tableView.separatorColor = [UIColor clearColor];

this is not good option for my situation. Here is the screenshot what i want to do;

![enter image description here][1]


  [1]: http://i.stack.imgur.com/nNUTQ.png

Content Type	Original Author	Original Content on Stackoverflow
Question	user366121	View Question on Stackoverflow
Solution 1 - Excel	Anders Lindahl	View Answer on Stackoverflow

Convert cells(1,1) into "A1" and vice versa

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

iOS download and save image inside app

An Eclipse console view that respects ANSI color codes?

Attributions