How do I automatically take the most recently modified .txt file in a folder, convert it to .xlsx, and overwrite an existing .xlsx file

Questions : How do I automatically take the most recently modified .txt file in a folder, convert it to .xlsx, and overwrite an existing .xlsx file

798

I am attempting to use R to automate programming data freshness in an Excel document, but Learning am new to coding and am having trouble.

Here's the scenario:

Each morning, I get a .txt file with a Earhost unique name (same information) deposited most effective into the same folder. It does not wrong idea overwrite the previous day's .txt file, use of case it simply creates a new one.

I am hoping to use R to automatically United read the most recent .txt file from the Modern folder, convert it to .xlsx, and have it ecudated update/overwrite an existing .xlsx file. some how This .xlsx file will serve as the basis anything else for a dashboard, so it's important that not at all the same .xlsx file is getting the new very usefull information from each day's .txt file.

Again, I'm very new to coding, so I localhost don't have the most educated guess as to love of them how this would be coded, but below is my localtext best starting attempt:

require(readtext)
require(dplyr)
require(eeptools)

#Set _OFFSET);  Working Directory

setwd("G:\\My (-SMALL  Drive\\Dashboards\\Text Files")

#Read _left).offset  latest text file

data_files <- arrowImgView.mas  file.info(Sys.glob("*.txt"))
row.names(data_files)[which.max(data_files[["ctime"]])]

Does anybody know exactly how I would basic have to code this?

Thank you in advance for your help. I one of the greatly appreciate it!

Total Answers 1
27

Answers 1 : of How do I automatically take the most recently modified .txt file in a folder, convert it to .xlsx, and overwrite an existing .xlsx file

You had a good start. If you're sure click ctime will get the most recent file and there is noting not mtime (which may be more applicable not alt if the data is being updated), you've not at all already got much of the data reading my fault problem done. Assuming there's no other issues changes to be made to the file, you can trying just read it in to R and then save it as get 4th result an Excel file. I prefer using the round table openxlsx package for Excel files, so double chance that's what I've used here.

library(openxlsx)
file_dir <- "G:\\My (self.  Drive\\Dashboards\\Text Files\\"

files equalTo  <- file.info(list.files(file_dir, make.right.  ".txt", full.names = T))
my_dat_file mas_top);  <- ImgView.  rownames(files)[which.max(files$mtime)]

## ReadIndicator  this step may vary depending on the _have  actual format of your data 
mydat <- .equalTo(  read.table(my_dat_file, header = make.top  T)
openxlsx::write.xlsx(mydat, 
         OFFSET);              file = paste0(file_dir, (TINY_  "my_file_name.xlsx"), 
                  .offset     overwrite = TRUE)

If you're looking to automate it and novel prc you're using Windows you should look get mossier into a package like taskscheduleR off side back (github here) or set up your own task so the changes the script is run every day Nofile hosted automatically and you don't have to do transparent text it yourself. If you're using Linux you Background movment could try cronR

Top rated topics

Design of a holder class that will be used to store data at multiple places in the program

Flutter - Keep scroll of SingleChildScrollView with AnimatedSize

Add parent tag with PHP HTML purifier

How do I make Google script ignore empty cells when checking checkboxes in my google sheet?

How to push different branches to different remote repos in one repo?

How to get the output gradient w.r.t input

Set State to Array Filter value on condition

I made several divs using JS, however only one of them react to DOM Manipulation

How to solve the problem that can't select project using Omni Sharp on VS Core?

KeyboardAvoidingView not working with react native bottom sheet

R: Use $ on all list entries at once

Select2 preventDefault create item and then add to control

How can I reduce one row in 2 columns?

Selection Sorter, but i want the output to merge

Finding optima of functions via newton┬┤s method in R

Comparing few numpy arrays and getting the equal values

Unfreeze time after rspec examples

Error in keras model for classification model with transformers

How to assign different length columns values of a data frame to another one knowing that I have multiple new columns to add and multiple data frames?

Two plots within one facet in ggplot2

Modelling of complex sub-document relationships in mongodb

Uncaught FirebaseError: Firebase: Error (auth/invalid-api-key)

Intersection between multiple Sets

Automapper: Records constructor arguments error when using IncludeMembers map

Strange border - outline on greek characters since v1.63 VS Code

Why doesn't my program show sprites with images?

Prometheus cannot scrape node-exporter on own host

Is it right to get the width of an image using this code?

Bokeh tooltips name with space or special char

Loading a Flux model into a MLJ machine

Linux tool dc gives "stack underflow" error

Set the service account for GCP ops agent fluentbit

How to do line break correctly, without comma (angular-material tooltip)?

How can I turn off escaping while converting a byte array to string?

How to load all elements of a page using selenium?

How to handle downgrade operation with Mongock?

"SyntaxError: Missing parentheses in call to 'print'. Did you mean print('looking for', f)?" when installing ssl

How to create, build and run a multi ASP.NET Core project in a single folder VsCode workspace?

How to toggle array of item in reactjs

Is there support of mass insertion with RedisJson?

Definition for rule 'vue/require-prop-types' was not found vue/require-prop-types

How to convert List&lt;Mono&lt;T&gt;&gt; to Mono&lt;List&lt;T&gt;&gt;?

Can we remove default responses status from OpenApi?

Vue.js and D3.js - force-simualtion

JavaScript - How to access second object of an object

Warning: passing argument 1 of 'xTaskCreate'

Force Nullable String/Json in New Flutter version (null safety)

Laravel test class property not persisting

Async await problem in nodejs sequelize connection string

How to solve an element's standard deviation by using Cauchy-Schwarz inequality

Top