Search Results

I have lots of workbooks on a given format. The workbooks explain a series of certain objects. I don't want to reveal exactly what this is, so I'll refer to it as just an "Item". I need to do the foll …

I have an Excel workbook with two sheets: "Raw data" and "Summary". … I want to create a list of words ("Knife", "Fork" .. ) and write it to Excel in one command. The way I'm doing it now is to manually write each item name. …

This is a follow up question: I have an Excel workbook with two sheets: "Raw data" and "Summary". … I want to create a list of words ("Knife", "Fork" .. ) and write it to Excel in one command. The way I'm doing it now is to manually write each item name. …

I want to create a list of random integers in the range [0, 9], that sums up to 100 in Excel, using VBA. The list should be printed in a single column. … Should I delete the (100-i) last elements of the list somehow, before writing it to Excel? How and why? Is the last line a good way of writing to Excel, or is there a better way? …

I have hundreds of Excel-sheets looking something like this: I can't use the actual sheet, and not the exact document numbers, since they are confidential. … files are something like 2301 Item 1.xlsx 2014 Item 2.xlsx 5321 Item 3.xlsx 3212 Item 200.xlsx I want to change the names of these files, based on the document name that's given in cell C5 in each Excel-sheet …

This is a follow up to the simpler question here. I have hundreds of files looking something like this: These files have names such as: 2301 Item 1.xlsx 2014 Item 2.xlsx 5321 Item 3.xlsx 3212 Ite …

Can I simplify the way I'm creating datasheets and writing to Excel? Do I use enumerate as it should be used in the last 3 rows? Izero_3 is a np.array. … nodes_to] branch_string = [nodes_from_string[x] +'-' +nodes_to_string[x] for x in range(0, len(nodes_from))] #============================================================================== # Create Excel-file …