In fact, most of the transformations that come in the download are in the XML or JSON format!Īfter using this tool for several years, and sharing with my co-workers, it seemed a proper time to share with the rest of the world. Where the real power is in your ability to write your own transformations in XML or JSON. The Excel to SQL transformation takes the Excel input and makes it simple to paste that Excel data into a SQL #Temp table, which I can then use to import or analyze the issue. To get that into our production database on the other side of the firewall was a pain. Given I was doing that many times a day, I needed a solution, and this is that solution.Ĭonversely, I would regularly get Excel workbooks from users asking me to import/export/explain some piece of data. That's a lot of busy work just to display a table of data. After having to alter text to make it fit some need over and over and over again, I finally realized what I need to do is be able to programmatically alter the text in my clipboard without having to go to some intermediate tool.įor example, without this tool, to send results from SQL Server Management Studio to my co-worker, I would copy the results with headers, launch MS Excel, paste into Excel, format in Excel, copy from Excel, paste into the email to be sent. The most powerful one is taking an Excel sheet and transforming it into a SQL temp table script. One of my favorites is copying the top row of a SQL result set from MS SQL Server Management Studio, and transforming it into a column list to make selecting and re-arranging the columns easier. Or, splitting a string of numbers and getting a distinct, sorted subset for analysis on paste. This can be quite powerful, for example, copying a range of data in Excel (unformatted) and then transforming it into a pretty table to be pasted into an email. This Windows desktop application, while running, monitors your clipboard, and allows you to alter the contents before you paste. Note: You will need to "Update Packages" to get NuGet dependencies before compiling. Download TransformClipboard Application Only (1.2M)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |