excel两列日期筛选相同
Last week, someone asked if I could stop zipping the sample Excel files that you can download from my website. Well, I thought about it carefully, and decided to leave things as they are. Excel helped me decide, and you can get the macro that I used, to list all Excel files with dates and sizes.
上周,有人问我是否可以停止压缩可从我的网站下载的示例Excel文件。 好吧,我仔细考虑了一下,并决定保留原样。 Excel帮助我做出决定,并且您可以获得我使用的宏,以列出具有日期和大小的所有Excel文件。
为什么要压缩文件? (Why Zip the Files?)
The person who asked me to stop zipping the files noted that "These days, difference between a 30 and 40KB download is trivial."
要求我停止压缩文件的人指出:“这些天,下载30KB和40KB之间的差异很小。”
That's true for most people, I'm sure, although there must still be some people on slower internet connections.
我敢肯定,对大多数人来说都是如此,尽管仍然有一些人的互联网连接速度较慢。
But what's the real size difference between zipped and unzipped Excel files? Is that 30/40 kb example valid?
但是,压缩的和未压缩的Excel文件之间的实际大小差异是什么? 那30/40 kb的示例有效吗?
很久以前的文件 (Long Ago Files)
My Contextures website went online in November 2000, and the Wayback Machine site has archived copies of my Excel Sample Files page.
我的Contextures网站于2000年11月上线,而Wayback Machine网站已存档了我的Excel Sample Files页面的副本。
That year, there were only 4 files listed on that page. Three files were available in both XLS and zip format, and one file was in XLS format only.
那一年,该页面上仅列出了4个文件。 XLS和zip格式都有3个文件,而XLS格式只有1个文件。
尺寸差异小 (Small Size Difference)
As you can see, all the files were quite small, and the zipped files were about 1/4 to 1/3 of the original size.
如您所见,所有文件都非常小,压缩后的文件大约是原始大小的1/4到1/3。
There were a couple of benefits for zipping the sample files:
压缩示例文件有两个好处:
- Less storage space and bandwidth for my website 我的网站的存储空间和带宽更少
- Smaller files for people on slow internet connections – more people had those in 2002 互联网连接速度慢的人的文件较小-2002年有更多人使用的文件
Unfortunately, I can't find download records from 2002, so I'm not sure which format was more popular.
不幸的是,我找不到2002年的下载记录,所以我不确定哪种格式更受欢迎。
今天的尺寸差异 (Size Difference Today)
But what about today's Excel files? Is it still worth zipping them?
但是今天的Excel文件呢? 仍然值得压缩它们吗?
To get a size comparison, I checked one of my current downloads – the Sample Data file that you can get from the sample data page.
为了进行大小比较,我检查了当前下载的文件之一-您可以从样本数据页面中获取样本数据文件。
The XLSX file is 65 KB and when zipped, the size only reduces by 8%, to 60 KB
XLSX文件为65 KB,压缩后的大小仅减少8%,为60 KB
压缩的其他好处 (Other Benefits of Zipping)
That 8% difference isn't much, for the person who's downloading the file. If they downloaded the XLSX file, it would only take a bit longer, and they'd save the step of unzipping the file.
对于下载文件的人来说,8%的差异并不大。 如果他们下载了XLSX文件,则只需更长的时间,他们将节省解压缩文件的步骤。
From my perspective though, it's not just one download. My site has hundreds of thousands of free Excel files downloaded every year. That's lots of bandwidth, and saving 8-10% is a substantial amount!
但是从我的角度来看,这不仅仅是一次下载。 我的网站每年都有成千上万的免费Excel文件下载。 那是很大的带宽,节省8-10%实在是一笔巨款!
安全问题? (Security Problems?)
Many of the sample files have macros too, and those might be blocked by company firewalls if they're unzipped.
许多示例文件也具有宏,如果未解压缩,则这些宏可能会被公司防火墙阻止。
Do companies prevent you from downloading Excel files with macros, if they're unzipped?
公司是否阻止您下载带有宏的Excel文件(如果已解压缩)?
Can you download them if they are zipped?
如果将它们压缩,可以下载它们吗?
保留旧链接 (Preserving Old Links)
Another reason for me to keep the zipped files on my site, instead of replacing them with unzipped files is to preserve all the links.
我将压缩文件保留在网站上而不是用解压缩文件替换的另一个原因是保留所有链接。
If I deleted all the zip files, all the old links would be broken, and that's never a good thing!
如果删除所有zip文件,所有旧链接将被破坏,那绝对不是一件好事!
So, I'd have to upload a second copy of each sample file, with a new link to the XLSM or XLSX file (doubling my file storage), and creating a ton of work for myself. That's never a good thing either!
因此,我必须上载每个样本文件的第二个副本,并带有指向XLSM或XLSX文件的新链接(使文件存储量增加一倍),并为自己创建大量工作。 这也不是一件好事!
获取Excel文件列表 (Get a List of Excel Files)
So I'll be leaving things as they are, with zipped sample files, unless someone can convince me to do otherwise.
因此,除非有人能说服我执行其他操作,否则我将使用压缩的示例文件保留原样。
And as promised, you can get a macro to list all the files in a folder, with their name, size and creation date.
如您所愿,您可以获得一个宏来列出文件夹中的所有文件,以及它们的名称,大小和创建日期。
Go to the Excel Folder File Macros page on my Contextures site, and there are 3 different workbooks to download (in zipped format!)
转到我的Contextures网站上的“ Excel文件夹文件宏”页面 ,有3种不同的工作簿可供下载(压缩格式!)。
The quickest macro is the one that lists all Files. Put the file path in the worksheet cell, and the macros adds a new sheet with the file list.
最快的宏是列出所有文件的宏。 将文件路径放在工作表单元格中,宏将添加一个带有文件列表的新工作表。
您是否压缩文件? (Do You Zip Your Files?)
If you have an Excel blog or site, do you zip your sample files?
如果您有Excel博客或网站,是否可以压缩示例文件?
If so, is it to save space and bandwidth, or another reason?
如果是这样,是为了节省空间和带宽,还是其他原因?
翻译自: https://contexturesblog.com/archives/2019/06/13/list-all-excel-files-with-dates/
excel两列日期筛选相同