`Application.Caller` returns the range object that the UDF is called from.

I need to implement hash value i.e the Url should look like this:
    
&gt;/home/index/#create

For this have added a route:
    
    routes.MapRoute(
        &quot;Default&quot;,    // Route name
        &quot;{controller}/{action}/#{detail}&quot;,    // URL with parameters
        new { controller = &quot;Login&quot;, action = &quot;LogIn&quot;,  detail  =&quot;&quot;}  // Parameter defaults
    );

On accessing `/home/index/#create`, it is redirecting me to the default route.

How can this be done?

Including hash values in ASP.NET MVC URL routes

What is considered the best practice in placing the `@Transactional` annotation? Should I annotate the interface method or the implementation?

Where to put @Transactional? In interface specification or implementation?

How can I get the cell where my VBA Function is called from?

In other words, what is the VBA equivalent for INDIRECT(ROW(), COLUMN()) ?

I&#39;m *not* looking for **ActiveCell**.

What I want to do is have a simple function `ThisRow_Col(rColumn As String)` return the column X of the row it&#39;s called from. Say in B2 I call =ThisRow_Col(&quot;A&quot;), it should return the value of A2. This should work regardless of which cell active.

**EDIT**: Thanks Charles for the answer: **Application.Caller**. The following code gets the column X of the current row, independent of where the selection is:

    Function ThisRow_Col(rColumn As Range)
        &#39; Return INDIRECT(rcolumn &amp; ROW())

        ThisRow_Col = Application.Caller.Worksheet.Cells(Application.Caller.Row, rColumn.Column).Value

    End Function

Note that passing the column as a Range (`ThisRow_Col(A1)`) is better than passing it as a string, because Excel can automatically update the formulas if you move or insert columns. Of course the `1` row of `A1` is just a convention.

Excel cell from which a Function is called

How can I get the cell where my VBA Function is called from?
In other words, what is the VBA equivalent for INDIRECT(ROW(), COLUMN()) ?
I'm not looking for ActiveCell.
What I want to do is have a simple function <code>ThisRow_Col(rColumn As String)</code> return the column X of the row it's called from. Say in B2 I call =ThisRow_Col("A"), it should return the value of A2. This should work regardless of which cell active.
EDIT: Thanks Charles for the answer: Application.Caller. The following code gets the column X of the current row, independent of where the selection is:
<pre><code class="hljs language-scss">Function ThisRow_Col(rColumn As Range)
 ' Return INDIRECT(rcolumn &#x26; ROW())

 ThisRow_Col = Application.Caller.Worksheet.Cells(Application.Caller.Row, rColumn.Column).Value

End Function
</code></pre>
Note that passing the column as a Range (<code>ThisRow_Col(A1)</code>) is better than passing it as a string, because Excel can automatically update the formulas if you move or insert columns. Of course the <code>1</code> row of <code>A1</code> is just a convention.

Does anybody here know how to get VBA to run multiple threads? I am using Excel.

Multi-threading in VBA

I am using EPPlus to generate an XLSX file in C#. As soon as I instantiate the ExcelPackage with a memory stream - I get the error:

&gt;&quot;A disk error occurred during a write operation. (Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))&quot;

Code is:

    MemoryStream stream = new MemoryStream();

    using (ExcelPackage package = new ExcelPackage(stream))
    {
        ...
    }

Has anyone else seen this?

Using EPPlus with a MemoryStream

Somehow I manage to create new rows between two rows in an existing excel file. The problem is, some of the formatting were not include along the shifting of the rows. 

One of this, is the row that are hide are not relatively go along during the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a create new rows the formating still there. The hidden rows must also move during the insertion/creation of new rows, it should be 21 to 31. 

Another thing is, the other object in the sheet that are not in the cell. Like the text box are not move along after the new row is created. Its like the position of these object are fixed. But I want it to move, the same thing as I insert a new row or paste row in excel. If there is a function of inserting a new row, please let me know.

This what I have right now, just a snippet from my code.

    HSSFWorkbook wb = new HSSFWorkbook(template); //template is the source of file
    HSSFSheet sheet = wb.getSheet(&quot;SAMPLE&quot;);
    HSSFRow newRow;
    HSSFCell cellData;

    int createNewRowAt = 9; //Add the new row between row 9 and 10
    
    sheet.shiftRows(createNewRowAt, sheet.getLastRowNum(), 1, true, false);
    newRow = sheet.createRow(createNewRowAt);
    newRow = sheet.getRow(createNewRowAt);

If copy and paste of rows is possible that would be big help. But I already ask it here and can&#39;t find a solution. So I decided to create a row as an interim solution. I&#39;m done with it but having a problem like this. 

Any help will be much appreciated. Thanks!

How to insert a row between two rows in an existing excel with HSSF (Apache POI)

I&#39;m looking for an Excel library which reads/writes .xls (not .xlsx) files.

I&#39;m using &lt;a href=&quot;http://code.google.com/p/excellibrary/&quot;&gt;excellibrary&lt;/a&gt; but it&#39;s very buggy and I &lt;a href=&quot;http://code.google.com/p/excellibrary/issues/detail?id=60&quot;&gt;can&#39;t seem to open the files I create&lt;/a&gt;. The issue has been known for almost a year and hasn&#39;t been fixed yet.

I&#39;ve seen in another thread someone suggested &lt;a href=&quot;http://epplus.codeplex.com/&quot;&gt;EPPlus&lt;/a&gt;, but that only works with the 2007/2010 .xlsx format.

I&#39;ve used &lt;a href=&quot;http://sourceforge.net/projects/koogra/&quot;&gt;Koogra&lt;/a&gt; in the past, and been quite happy with it, but I believe it can only read... not write.

If you know of a library, please let me know what it&#39;s called.

Edit:
I&#39;m quite happy to create my Excel file with the built-in Microsoft.Office.Interop.Excel if necessary, however my machine has Office 2007 and the target machines only have Office 2003. I noticed I have 2 file versions for that library: 12, and 14. I checked the Excel version on the target machines and it&#39;s 11.8169.8172 - I&#39;m assuming that the built-in Excel interop will not work on the target?

.NET Excel Library that can read/write .xls files

I found NPOI is very good to write Excel files with C#.

But I want to open, read and modify Excel files in C#.

How can I do this?

How to read file using NPOI

After I add some values to the VBA collection, is there any way to retain the list of all keys?

For example

    Dim coll as new  Collection
    Dim str1, str2, str3
    str1=&quot;first string&quot;
    str2=&quot;second string&quot;
    str3=&quot;third string&quot;
    coll.add str1, &quot;first key&quot;
    coll.add str2, &quot;second key&quot;
    coll.add str3, &quot;third key&quot;

I know how to retain the list of strings:

    first string
    second string
    third string

Once again: is there any way to retain the keys?

    first key
    second key
    third key


Note: _I&#39;m using VBA through AutoCAD 2007_

VBA collection: list of keys

I have the following code 

    
    For x = LBound(arr) To UBound(arr)
      
        sname = arr(x)  
        If instr(sname, &quot;Configuration item&quot;) Then  
            &#39;**(here i want to go to next x in loop and not complete the code below)**  
    
        &#39;// other code to copy past and do various stuff
    
    Next x  

So I thought I could simply have the statement `Then Next x`, but this gives a &quot;no for statement declared&quot; error.

So what can I put after the `If instr(sname, &quot;Configuration item&quot;) Then` to make it proceed to the next value for x?

Continue For loop

I want to do this but it won&#39;t compile:

    Public MyVariable as Integer = 123

What&#39;s the best way of achieving this?


Is it possible to declare a public variable in vba and assign a default value?

I&#39;ve been working with VBA for quite a while now, but I&#39;m still not so sure about Error Handling.

A good article is the one of 
 [CPearson.com](http://www.cpearson.com/excel/errorhandling.htm)


However I&#39;m still wondering if the way I used to do ErrorHandling was/is completely wrong:
**Block 1**     

    On Error Goto ErrCatcher
       If UBound(.sortedDates) &gt; 0 Then

           // Code

       Else
    ErrCatcher:
           // Code

       End If


The if clause, because if it is true, will be executed and if it fails the Goto will go into the Else-part, since the Ubound of an Array should never be zero or less, without an Error, this method worked quite well so far.

If I understood it right it should be like this:

**Block 2**

    On Error Goto ErrCatcher
        If Ubound(.sortedDates) &gt; 0 Then
	
	       // Code
        End If

        Goto hereX

    ErrCatcher:
	       //Code
        Resume / Resume Next / Resume hereX

    hereX:


Or even like this:
**Block 3**

    On Error Goto ErrCatcher
        If Ubound(.sortedDates) &gt; 0 Then
	
           // Code
        End If

    ErrCatcher:
        If Err.Number &lt;&gt; 0 then
           //Code
        End If


The most common way I see is that one, that the Error &quot;Catcher&quot; is at the end of a sub and the Sub actually ends before with a &quot;Exit Sub&quot;, but however isn&#39;t it a little confusing if the Sub is quite big if you jump vice versa to read through the code?

**Block 4**

&gt; Source of the following Code: 
 [CPearson.com](http://www.cpearson.com/excel/errorhandling.htm)

      On Error Goto ErrHandler:
       N = 1 / 0    &#39; cause an error
       &#39;
       &#39; more code
       &#39;
      Exit Sub

      ErrHandler:
 
       &#39; error handling code&#39;

       Resume Next

    End Sub 


Should it be like in Block 3 ?

Properly Handling Errors in VBA (Excel)

I&#39;d like to make some cells of html table editable, simply double click a cell, input some text and the changes can be sent to server. I don&#39;t want to use some toolkits like dojo data grid. Because it provides some other features. Would you provide me some code snippet or advices on how to implement it?

How to make HTML table cell editable?

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

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

Content Type	Original Author	Original Content on Stackoverflow
Question	Dan Dascalescu	View Question on Stackoverflow
Solution 1 - Excel	Charles Williams	View Answer on Stackoverflow

Excel cell from which a Function is called

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Where to put @Transactional? In interface specification or implementation?

Including hash values in ASP.NET MVC URL routes

Attributions