Tag Archives: sed

How can I transform rows into repeated column based data?

Questions: I’m trying to take a dataset that looks like this: And transform the records into this format: The resulting format would have two columns, one for the old column names and one column for the values. If there are 10,000 rows then there should be 10,000 groups of data in the new format. I’m… Read More »

How do I report a bug to Microsoft? [closed]

Questions: I found a Bug in Microsoft Excel that has obviously been in there for many years. I use Excel via API and therefore this component needs to be fixed. The following discussion: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-do-you-report-a-product-bug-to-microsoft/0ef12a13-78eb-40c1-b946-f963cbe26b6e just yields: https://feedback.office.microsoft.com/default.aspx?productkey=office2007 but that seems to be outdated. How do I report a bug to Microsoft? Answers: Microsoft does not… Read More »

Reduce the file size of Excel [closed]

Questions: I’m working in an excel application and providing a menu to the user to add a new worksheet in that excel application (Excel Workbook). The worksheet will be added once the user clicks the “OK” button and I’m using a template to add this worksheet (The template has lot of formatting and formulas in… Read More »

Add if row contains a string in excel [closed]

Questions: Without the use of macros or anything fancy, is it possible to write an excel formula that would add up Col-1 rows that correspond to Col-2 rows having the string ‘st’? +—-+——-+——-+ + # + Col-1 + Col-2 + +—-+ ——+——-+ + 1 + 1 + an st + + 2 + 2 +… Read More »

Find the biggest change in values in a list? [closed]

Questions: How would you find the biggest difference/change in values of a list of numbers in Excel? An example of what I’m looking for is 1,3,4,5,9,10,11,13 The value I would look for is 4 as this is the biggest difference (between 5 and 9). Is there a way to do this with a list in… Read More »

How can i write to an excel using Microsoft.Office.Interop.Excel.Application in c# [closed]

Questions: I would like to have a simple example to write to an Excel spreadsheet using the Microsoft.Office.Interop.Excel.Application objects in c# Any one please help Thanks Answers: Interop is not supported in server scenarios (like ASP.NET) according to MS. There are many options to read/edit/create Excel files without Interop/installing Excel on the server: MS provides… Read More »

Non-commercial C# Library to format Excel? [closed]

Questions: I have a list of reports that are exported to excel through some reporting services, and on my server i need to loop through these spreadsheets and perform additional formatting e.g. 1) hide columns 2) rename sheets 3) freeze panes 4) set default zoom, print size, etc. 5) save as html or convert to… Read More »

How to detect if a specific key was pressed?

Questions: I’m wondering is there a way to detect if a specific key (like backspace) was pressed. This is what I’m shooting for: Private Sub SomeTextBox_Change() If len(Me.SomeTextBox.Value) = 3 and KEYPRESSED is NOT BACKSPACE Then <…….Code Here> Else <…….Code Here> End if End Sub Answers: You should use KeyPress event instead of Change event:… Read More »